Forum Discussion
Dynamic ranking based on slicer selection
Hi All -- Need one help with dynamic ranking based on slicer selection. Link has the PBIX file along with data. What I am trying to see is based on my year / month / quarter selection it should give ...
Hi,
It works fine. See the highlighted portion in the image
The reply by Anonymous has been marked as Answer. Have you tried that solution?
Yes that is not exactly this solution, solution is for the second part to basically make a graph dynamic and show us visual based on selection.
If i can rank data rows based on selection, I can then use a concatenate column and then use it in the graph to basically disguise the client names on x axis and use Client 1, Client 2 etc based on selection and rank assigned.
Hi,
I do not think that will help either because measures cannot be dragged to the X-axis of a graph. If you write a calculated column formula, then they will not respond to a change in slicers.
Is it. Ok thanks for your reply.