Add Visualization in Notebook to Dashboard, how to set default add to Dashboard Bottom

[Linglin]

I'm creating dashboard with multiple visualizations from a notebook.

Whenever I add a new visualization, the default position in dashboard is top left which mess up all the format I did for previous graph. Is there a way to default add to the bottom of the dashboard?

Thank you very much

[Kaniz]

Hi @Linglin, When creating a dashboard with multiple visualizations, it’s essential to consider the layout and placement of each visualization.

Here are a few approaches you can take to ensure a better arrangement:

1. Dynamic Comparison of Top and Bottom Performers:

   • If you’re using Microsoft Power BI, you can create a seamless display where both top-performing and underperforming items are shown alongside each other within a single table visual. This dynamic approach allows users to adjust the number of items they see in each section on the fly¹.
   • Here’s a step-by-step guide:
     1. Create a Disconnected Table for Dynamic Selection:
        • Set up a disconnected table in Power BI. This table lets users choose how many items they want to see in both the top and bottom sections of the visual.
        • Use the GENERATESERIES function to create a range of numbers representing the user’s selection.
        • Create a slicer using the column you’ve just created. This slicer will serve as a dynamic selector.
     2. Create a Measure for Ranking:
        • Create a measure that ranks the items based on your criteria (e.g., performance, sales, etc.).
        • Add this measure along with item IDs or names to the table visual. This will allow you to see the ranked items.
        • You can also add other measures or calculations to provide additional insights.
     3. Dynamic TopN/BottomN Selection with Intermediary Items:
        • Make a dynamic measure to select the top N and bottom N items based on the slicer’s selection.
        • Use the TOPN function twice: once in ascending order to find the bottom N items and once in descending order to find the top N items.
        • Include one or two rows between these two sets. To do this, use the RANK measure to determine the rank of items one or two positions above the selected N number.
        • Use the SWITCH function to assign a value of 1 if the items belong to the top N or bottom N categories or if their rank is one or two positions higher than the selected N number; otherwise, set the value to 0.

2. Layout Considerations:

   • When designing your dashboard, consider the layout. Humans naturally read from left to right and top to bottom. Therefore, using a grid layout helps your audience navigate dashboards independently and intuitively².
   • In tools like Tableau, you can organize your dashboard using horizontal or vertical containers. Drag views and objects into these containers to control their placement³.

3. Pin Entire Report Pages (Power BI):

   • If you’re working with Power BI, consider pinning entire report pages to your dashboard. This way, you can maintain the layout and order of visualizations as they appear in the report⁴.

Remember that thoughtful design and planning can significantly enhance the user experience when interacting with your dashboard. Feel free to explore these options and choose the one that best fits your needs! 😊📊

[shan_chandra]

@Linglin - Are you creating a legacy dashboard from the notebook results or using a Lakeview dashboard?

[Linglin · Accepted solution]

@shan_chandra I'm using Lakeview dashboard. In dbx notebook, there is Add to dashboard > button on the right of each visualization. It's super handy. 

Actually I have this issue solved. 

[shan_chandra]

@Linglin - I am glad the issue is resolved.