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

Drill-through with 0% in a chart

Hello guys, 

 

I hope you are well. 

 

I setup a drill through which I use in a chart with a % value like this one below : 

 

PBI 2.jpg

 

The issue is the drill throught works on the bar of the chart and not on the value. Therefore, I cannot drillthrough 0% in this chart. 

Do you have idea to by able to drill through 0% ? 

 

Many thanks for your help, 

 

 

 

 

 

3 REPLIES 3
Highlighted
Super User IV
Super User IV

Re: Drill-through with 0% in a chart

@ilyasss Great question and I don't see there is any solution for this, although with the new feature, you can use buttons for the drill-down, maybe you want to look into it.

 

https://docs.microsoft.com/en-us/power-bi/desktop-drill-through-buttons

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Post Prodigy
Post Prodigy

Re: Drill-through with 0% in a chart

@ilyasss you could change it to a table, and do conditional formatting to bring back the bars. You can format the table to make it look very similar, but then you should be able to drill through on the 0%.

 

Drillthrough0.JPG

Highlighted
Post Partisan
Post Partisan

Re: Drill-through with 0% in a chart

I have a work around for now. It's somewhat complicated that I am using a summary table and detailed table as the Drill-through. I believe the information I was trying to display was not as straight forward as clicking on one bar to drill through to see only that bar's information. Instead, the drill-through leads to a summary table, which also displays a 2nd table thath holds more detail. For now, I will close down this ticket. Thanks.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors