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

[mariyahd]

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.

[v-stephen-msft]

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.

[mahoneypat]

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

Pat

[mariyahd]

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?