Forum Discussion

amitabhk1971's avatar
amitabhk1971
Helper I
9 years ago
Solved

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...
Tips and Tricks
  • amitabhk1971's avatar
    amitabhk1971
    9 years ago

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

     

    Amitabh

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

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.)

 

 

 

 

 

 

 

 

 

 

 

 

2. Use two "clustered column chart". Click on one chart will filter the other one.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

amitabhk1971's avatar
amitabhk1971
Helper I
9 years ago

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