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
hi lherbert501 ,
here is my version, so we can discuss based on pbix stuff
https://drive.google.com/drive/folders/1QePQY6IYIrtwCr37GjHiIKObuA197OQG?usp=sharing
Can you tell me if this is OK or you need modifications?
You cannot click on a card to create a filter though
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
On your PBIX, if you changed the cards to single line tables, is it not possible to select the single line table that displays top category and use this as the interactive selector for the table?
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
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