Forum Discussion
Dynamic Ranking
Hello, no it is not possible as that is the value of a measure
You would like to see in the slicer the best and top categories ?
Can this work? You have in automatic the top category in the slicerhttps://drive.google.com/drive/folders/1QePQY6IYIrtwCr37GjHiIKObuA197OQG?usp=sharing
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hello, no it is not possible as that is the value of a measure
You would like to see in the slicer the best and top categories ?
Can this work? You have in automatic the top category in the slicer
https://drive.google.com/drive/folders/1QePQY6IYIrtwCr37GjHiIKObuA197OQG?usp=sharing
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hi FBergamaschi
Okay thankyou for confirming.
Im wondering if its possible to simply put the category field into that 1 line table at the top and put a measure visual filter on the 1 line table. e.g. ranking of the lowest thats not zero and set this to 1?
This way the category would still be dynamic
Yes indeed, I did that
same link
is that a solution now?
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI