TopN Filter 0 Value

[kinseld5]

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

[DamienJ]

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/

[kinseld5]

Hi DamienJ,

would like to utilise this graph yes, and was hoping there be some way to still show a bit of the bar chart even if the value is 0, if thats not possible then yes think ill have to check my other options.

Thanks

[DamienJ · Accepted solution]

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.

[kinseld5]

perfect, didnt realise the legends could be selected, thats the fix, thanks 🙂

[DamienJ]

🙂