Forum Discussion
Francesca-nz
3 years agoNew Member
Visual Filter TopN bug? - Only show first record in a visual based on a column
I have a table visual with a column 'names'. I have a second visual as a progress bar chart which should only show a measure for one person at a time: If no name is selected the first name from the t...
Anonymous
3 years agoNot applicable
As you can see in the above screenshot by default its showing the sales for first name from slicer i.e. Caribbean.
Check the below Screenshot as well.
And for the remining names, the visual will show the sales for that name only.
And for that i used the below measure.
in place of firstnonblank you can hardcode the value which you need to show default i.e. in your case its the first name from the table.
if your issue gets resolved, please mark by solution as answer.