Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a bar chart that I have been able to use as a drill through to another page. I know I can ctrl+click on two columns to select two (or more) values and I have them used as drill through filters. When I drill through, I don't seem to get both selected values. I put a card visual on the page so I could see what was selected but I only see one of the values. Also when I look down at the drill down filters showing, it also only shows one value. I had created a 'List of values' and put that on the card visual, thinking that would show me the values.
I also tried using a slicer to use instead of/in addition to the bar charts to see if that made a difference and then synced the slicers but I dont really want the user to be able to change the filter on the drilled through report so it doesn't really so what I want.
Any suggestions to get all selected values to pass through and show?
Solved! Go to Solution.
Hi @leeguth ,
It is not supported to drill through with multiple selected values in Power BI currently . There are two ideas about this issue, please vote it up : Multiple Values(row) Passing in Drill through feature and Drill through of multiple rows . And you may add your comments there to improve Power BI and make this feature coming sooner.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @leeguth , in the drillthrough page under drillthrough filters, turn on Keep All Filters.
This way all the selected values will be passed to the drillthrough page.
that is already set....
Ok then. Suppose you are trying to drillthrough with Year and Customer, click on Year(Don't use control+ click) and then right click on the Customer and drillthrough to the drillthrough page. It should work.
No, I am trying to select two values from the same field. For example, I am trying to choose active and unknown (see chart)
but when I get into the drill through page only one (I think it is the one where my mouse is when I right click to drill through) shows.
Also happens if I use this type of visual and drill through
This is what shows when I get into the drill through.
This is a list measure of the field Project State. I would expect it to show both active and unknown but as you can see only one is showing in the drill down.
it doesn't seem to be passing both selected values through.
Hi @leeguth ,
It is not supported to drill through with multiple selected values in Power BI currently . There are two ideas about this issue, please vote it up : Multiple Values(row) Passing in Drill through feature and Drill through of multiple rows . And you may add your comments there to improve Power BI and make this feature coming sooner.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thanks...that is a shame since there is an option to allow single or multiple choices....single choice seems to have its odd behavior too though.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |