cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

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

 

topn 0.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

5 REPLIES 5
Frequent Visitor

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/

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

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.

View solution in original post

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

🙂

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors