Forum Discussion
TopN Filter 0 Value
hi
have a topn filter, and im currently using it to link me to hourly and daily stats on other charts, however if the topn filter indicates a zero, there is no bar to select to act as the filter for the other charts. anybody have any ideas on what could be completed here?
just to use an example, the top3 worst offenders are WK0012L08A1, WM0003L08C1 and GA0077L08C1. If i want to to see the hourly and daily data for GA0077L08C1 i select the red bar chart showing 31 and the daily and hourly charts change, however if i want to identify why the other two ids are at 0 i have nothing to select in the graph to act as the filter
Hmm. Well the legends are clickable too and will show regardless of value. If you add your Y axis as a legend that might get closer to what you're looking for.
5 Replies
Are you committed to the graph? I'd be tempted to try out a table or matrix for the data instead - that way your zero values will be selectable.
You could also use Conditional Formatting to add Data Bars to the data, somewhat replicating the graph you currently have :)
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-conditional-table-formatting/
Hmm. Well the legends are clickable too and will show regardless of value. If you add your Y axis as a legend that might get closer to what you're looking for.