Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Table measure linked to a button for dynamic filtering and swapping visuals

Hi all,


This may be a bit ambitious of a visualisation but hopefully someone can steer me in the right direction. I have a simple table with months and several measures, ex. calculate (distinctcount(id), responce = "positive"). My stakeholder needs to be able to select a value (month and measure) on this table and toggle to a more detailed visualisation (table or chart). So it's a toggle with filtering/drillthrough. 


I know how to build a static toggle but I'm not sure how to pass filters/drillthrough. I've tried quite a few things that didn't seem to work.


Thanks a lot for the help.

Community Support
Community Support

Hi @mariyahd ,


Please kindly refer to

Add a measure to drill through

Power BI - Measure Drillthrough




Best Regards,

Stephen Tao


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


Please see this documentation page and/or video on the drill through feature.

Set up drill through in Power BI reports - Power BI | Microsoft Docs

(7) Drilling into drillthrough in Power BI Desktop - YouTube


Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Hi Pat,


Thanks for that. However I need to drill on measure that uses calculate. I've read some workarounds but none of them have worked in my case. Any suggestions?

Helpful resources

August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors