Power BI: Dynamically top N rank for multiple columns in the matrix using RANKX, SWITCH & ISINSCOPE

This video will help you filter based on rank for multiple columns in matrix visual
Check for my other video for:
Power BI: Trick How to Display All Axis Values, Even When Data is Missing | Show Item with no data: • Power BI: Trick How to...
Power BI: Dynamically Display the Last X Months & next Y months of Data with Slicer Selection: • Power BI: Dynamically ...
Power BI: How to reset dashboard using reset bookmark | Clear All filters: • Power BI: How to reset...
Power BI: Dynamically Display Last 12 Months of Data with Slicer Selection till the Selected Date: • Power BI: Dynamically ...
Power BI: Format Bar chart with alternate color for bar I Conditional Format I Rank function: • Power BI: Format Bar c...
Power BI: Create custom tooltip | Tips for creating a tooltip | Enhance dashboard using tooltip: • Power BI: Create custo...
Power BI: Create Conditional columns using Edit query | by creating measures using nested IFs: • Power BI: Create Condi...
#powerbitutorials #powerbi #dashboard #powerbidashboard #switch #dynamic #dax #bookmark #english #datascience #dataanalytics #data #showhide #hide #bookmark #selection #tutorial #tutorials #powerbitutorial #powerbitutorials #powerbi #powerbipro #powerbitutorials #Exclude #sort #custom #column #college #customsort #tutorial #datascientist #tableau #formatting #axis #powerbitips #powerbitutorialforbeginners #powerbitelugu #interaction #slicer #filter #actual #sales #target #formatting #grandtotal #subtotal #percentage #calculation #clubsterbar #condition #conditionalformatting #column #tooltip #tooltips #barcharts #selection #highlights #highlight #gauges #dail #gauges #dynamic #swtich #paramter #clear #all #filter

[@unnikrishnansanthosh]

very helpful, thank you for sharing

[@Howtosolveprobem]

You are so welcome!

[@Vanessa-mo5xg]

could we only apply the rank dynamic to city level and state level remain unchanged?

[@Howtosolveprobem]

when you say state level remain unchanged meaning?? cab you please elaborate??

[@Nalaka-Wanniarachchi]

Good video,can you share the pbix file

[@Howtosolveprobem]

Hi Thanks for the feedback, here the link for power bi: drive.google.com/file/d/12xVut6anmtEcQJXsLfMwbaZ_bhLUVbzB/view?usp=sharing

[@MusicalShorts-hn1px]

Can we have this dataset used in the video

[@Howtosolveprobem]

this is open source sale super store data which can be downloaded easily or you can download from this data.world/missdataviz/superstore-2021