Create dynamic Pie chart in Power BI | Dynamic TOP N Slicer Selection
Vložit
- čas přidán 19. 12. 2022
- Dynamic Top N Slicer Selection in Power BI using DAX Measures without creating any kind of Bookmarks. In this video, I have shown the trick by which you can make your charts dynamic without creating any bookmarks in the report.
Learn Power BI through my other Videos :
1.End to End Power BI Project in 40 min: • End to End Power BI Pr...
2.How to Create Bookmark with a Slicer in Power BI: • How to create Bookmark...
3.Create dynamic charts with TOP N : • Create dynamic Pie cha...
4.How to Join Two Tables with Multiple columns in Power BI: • How to Join Two Tables...
5.How to Create a Date Table in Power Query: • How To Create a Date T...
6.How to Create a Date Hierarchy in Power BI: • How To Create A Date H...
7.Most useful DAX shortcuts in Power BI: • Most Useful DAX Shortc...
8.End to End Power BI Project using NLP in 15 min: • End to End Power BI Pr...
9.DISTINCT vs VALUES: • End to End Power BI Pr...
10.Generate Dates between Start Date and End Date in Power BI : • Generate dates between...
Dynamic Top N Slicer Selection in Power BI ,
Choose Top 5, Top 3 dynamically in the visualizations,
Pie chart with dynamic Top N,
How to create Dynamic Top N filter in Power BI,
How to add a slicer for TOP N in Power BI,
How to show Top N visual with creating any bookmarks,
Show Dynamic TOP N Slicer selection in Power BI,
How to write a DAX logic for TOP N slicer in Power BI,
How to choose TOP N Products in Slicer in Power BI,
Dynamic TOP N with DAX,
Dynamic Top N logic in Power BI with Measures
#powerbi #dax #tutorial - Věda a technologie
Everything is good but I want to Display values even if I won't select filter slicer
The values are displayed only after selecting filter slicer
In this scenario, you can add one more category in the slicer as All and put the value as 1000 or more where when selecting All it will show all the categories in your pie chart
@@bitricks thank you very much
@@bitricks But we do not want select any slicer they what should do?
We can also create a field parameter and use it similar way instead of creating a table using enter data. The explanation really helped me. Thanks!
Hey...
I want a different columns should add which is named as OTHERS so if the user is selected TOP 2 then in Bar chart it should show 3 columns such as - TOP 2 values and an OTHERS columns which is sum of profits(exclude the profit of the top 2 columns)
How can we show others
May I know how the profit measure column is created? Because when I try to use it, I see this profit is a measure. May I know what it refers to?
It is a simple sum of profit measure
Hello Sir, I have different measures like Profit, revenue ,based on product, customer , employee .So Will I need to Make different different TopN Condition measures for product revenue ,product profit, customer profit,employee profit as u made one topN condition for product??
Yes if you have different axes in that case you will have to create different measures
Hello dear, when i am trying to create rankx measure and adding profit column from the existing table it is showing error. How you created profit measure ? How to remove error
Profit measure is simple sum of profit
Hie Sir, Nice video, can u make a video of full company analysis from yahoo finance of a particular company & present one Bi Dashboard
Will try
In case of no slicer selection, I want to show default visual for Top5 instead of showing blank...
How can we achieve this?
You can add an if else condition in the conditional measure. If its filtered it will check for the filtered value else if its not filtered it should return top 5 values. You can use ISFILTERED dax function to get this result