Comparing 2 or more Columns in Bar Chart with Drillthrough

[MannyJ]

Hi there.

I've got a bar chart with different properties, their electricity usage, as well as the cost. See below:

I would like to create a drillthrough page whereby I can select 2 (or more) bars and then drillthrough to another page which would show the two properties selected in 2 separate bar charts identical to the one above but with days on the x axis instead of property. It could also work if it was 1 chart with the 2 selected properties on it and grouped by day/month.

Can anyone help with how I can do this?

[v-yueyunzh-msft · Accepted solution]

Hi , @MannyJ 

According to your description, you want to select muti-property and then drill through.

For the initial Drill Through, it supports us to select a single, so the only way at present is to use Card visual as the button of Drill Through.

We can create a measure to put in the card:

Measure = IF( ISFILTERED('Table'[Property]) , "drill through" , "You can select")

Then we can create another page we want to drill through and put the field and the measure on the "Drill through":

Then we can select muti-property and then right click the card visual :

The result is as follows:

For this , you can refer to :
Create a Multi-Selection Drillthrough "Button" in Power BI - Bing video

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[MannyJ]

Hi @v-yueyunzh-msft is there a way that when the two properties are selected and it goes to the drill down page, the cost that is being displayed is also split between the two properties (maybe 2 cost lines for each property or maybe an indication in the tooltips)?

[MannyJ]

Thank you so much for your help Aniya! This is brilliant. This will certainly be a great solution! Stay blessed!

[v-yueyunzh-msft]

Hi , @MannyJ 

Thanks for your quick response! And i test it in my side , it seems difficult to set the line to more lines in this viusal . And you can try to use the tooltip page feature.

Create report tooltip pages in Power BI - Power BI | Microsoft Learn

You can create a page as tooltipPage:

Then you can set it to the visual:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[MannyJ]

Thank your so much! This worked perfectly!