Forum Discussion
Dynamic ranking based on slicer selection
Hi,
It works fine. See the highlighted portion in the image
Hi Ashish,
Solution is great however, I have a quick question related to this if you can please answer?
I am making a selection through Slicer/Filters where in the background data I have 42 distinct rows. When I create this rank formula, it assigns rank to all 42 but doesnt change (reduce) if i filter few through selection. Like I am making a selection that results in 8 data points, the column technically assign rank till 8 and not all 42 correct?
Please help?
Thanks
Thank you. That is an sold post. Please describe your question, share some data and show the expected result.
Yes this is an old post. You can find my question here where I am not able to get the solution.. If you can please.
Thanks much
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.