Forum Discussion
RANKX, virtual table, Filter on visual
Hey erniemon ,
as you already figured out you can use calculated columns as filter, but not measures as they always need a context.
You have to filter the visuals to your projects and then with the measure return the top 7 for each project.
Thanks, So I filter first ok, then I RANKX ok, how do I display seven different donuts setting up each one to Filter on the visual using the measure returning the RANKX? When I use the measure in a table it displays the rank perfectly. when I place the measure in the filter on this visual no action. I put the measure on a card, says (Blank)". So After I have sliced the data, how can I display seven individual donuts by RANK.
I am using three tables, a master projects table with all tasks, and about 20 projects. A summary table linked by project name. Lastly, a Project name table also linked through the project name.
This display is using a column in a table that has a rank. Using filter on this visual
Each donut has the value 1,2,3,4,5,6,7. displaying the bottom seven projects. When I filter the rank doesn't work. So I created a measure to rank, and it gives me the proper ranking. Only works in a table or matrix.
How to get the rank information from the measure to Filter on this visual?
Again I want to express my thanks for helping me.