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
Watch video Power BI Dynamically Rank a Field Based on Measures | Hide and Unhide Rows | Show Top Ranks | RANKX online without registration, duration hours minute second in high quality. This video was added by user Life of Business Analyst 06 June 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,188 once and liked it 7 people.