Power BI Dynamically Rank a Field Based on Measures | Hide and Unhide Rows | Show Top Ranks | RANKX
This is a short video explaining on how to use Rankx function combined with other functions to dynamically hide or unhide rows in a matrix based on user selection in a slicer.
Sorry for keeping the video little lengthy because I have shown each and every step so that it's easy for the beginners to follow.
Other Videos which you might be interested:
1. Summarize Columns : • Power BI SUMMARIZECOLUMNS function
2. Change the color of Selected Button : • Power BI Change Button Color on Selec...
3. Hide and Unhide Visuals to optimize space : • Power BI Hide and Unhide Visuals | Us...
4. Earlier function : • Power BI EARLIER function
5. Selected Measure or Calculated group : • Power BI SELECTEDMEASURE or CALCULA...
6. DatesMTD, DatesQTD, DatesSYTD : • Power BI DATESMTD, DATESQTD and DATESYTD
7. Targets & Trend : • Power BI Measures shown in Rows in Ma...
8. Blank, Isblank, Isnumber, Istext : • Power BI BLANK, ISBLANK, BLANK with I...
9. Select Columns : • Power BI SELECTCOLUMNS function
10. Divide by Zero Error Handling : • Power BI Divide by Zero Error| Divide...
11. Mean , Median, Mode : • Power BI Mean(Average), Median & Mode...
12. Many to many relationship : • Power BI Many to Many Relationship
13. Count working days, exclude holidays : • Power BI Network days | Count Busines...
14. Weekly Rolling average : • Power BI Weekly Rolling Average | Wee...
15. Enable tabular editor : • Power BI Enable EXTERNAL TOOLS like T...
16. Add Columns : • Power BI ADDCOLUMNS function
17. Contains, Containsstring : • Power BI CONTAINS, CONTAINSSTRING & C...
18. Variance & Standard Deviation : • Power BI VAR.S and STDEV.S | Variance...
19. Row Number : • Power BI Row_Number Over Partition by...
20. Summarize : • Power BI SUMMARIZE function