cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amitabhk1971 Regular Visitor
Regular Visitor

drill down/Filters reports

Hi,

 

I have set up a report on Power BI. It has few histograms. The histogram has three categories on the x axis, compliant, Non-compliant and Out of date. The y axis has number of devices. So the chart shows number of devices which are compliant, Non-compliant and Out of date. Now I want to drill down such that when I click the bar for compliant I should get the list of compliant devices, when I click the non-compliant bar I should get the list of non-compliant devices and when I click the out of date bar I should get the out of date devices. I tried new heirarchies and filters but I could not get this result. Does anyone know how to set this up.

 

The second question is my chart is a histogram, I want the drilled down chart to be in tabular formt. Is it possible? If yes, how can I keep the format of the drilled down chart i.e. the lower heirachy chart to be in tabular format while the upper heirarchy chart is a histogram? 

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
amitabhk1971 Regular Visitor
Regular Visitor

Re: drill down/Filters reports

Thanks Dale, however I resolved the issue by rewriting the sql codes for the datasets.

 

Amitabh

3 REPLIES 3
Community Support Team
Community Support Team

Re: drill down/Filters reports

Hi @amitabhk1971,

 

Did you use a histogram visual from the store, which is a custom visual? If so, I am afraid the histogram visual doesn't have the ability to drill down according to my test. Maybe there are workarounds.

1. Use a "matrix" visual. You can click the categories to drill down. (One visual is needed, the other one is for comparison.)drill down Filters reports .jpg

 

 

 

 

 

 

 

 

 

 

 

 

2. Use two "clustered column chart". Click on one chart will filter the other one.drill down Filters reports2 .jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitabhk1971 Regular Visitor
Regular Visitor

Re: drill down/Filters reports

Hi Dale,

 

Thanks for your reply. In clustered column chart is it possible to set up the drill down reports as I mentioned? I tried but when I drill down to the lower level it shows all of the devices instead of only those which fall in the selected category, i.e. compliant/non-compliant/out of date.

 

Thanks,

Amitabh

Highlighted
amitabhk1971 Regular Visitor
Regular Visitor

Re: drill down/Filters reports

Thanks Dale, however I resolved the issue by rewriting the sql codes for the datasets.

 

Amitabh