topic Re: Pre-Filtering The Result Based on User Selection in DAX Commands and Tips

Pre-Filtering The Result Based on User Selection

Milan14 — Thu, 04 Nov 2021 07:36:17 GMT

Hi All,

I have a dashboard which mostly are tables, and I would like to pre-filter the result that show in another page by clicking on a button. For example, on my dashboard, I have two tables for two different channels (Channel A and Channel B) that showed under the same page with few details’ buttons are created. When I click on a details button for Channel A, it will navigate to another dashboard page with the details table that only show the information belonging to Channel A. This logic same goes for Channel B too.

Does anyone have any suggestions that could help?

Any help would be much appreciated.

Thanks in advance!

Kindly Regards,

Milan

Re: Pre-Filtering The Result Based on User Selection

BeaBF — Thu, 04 Nov 2021 08:53:17 GMT

Milan14 Hi!

What you would like to implement is called drillthrought and it is a feature present in Power BI.

Here you have a guide: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
If you have any doubts, ask me,
B.

Re: Pre-Filtering The Result Based on User Selection

v-cazheng-msft — Tue, 09 Nov 2021 08:26:19 GMT

Hi Milan14

If you would like to navigate current dashboard users to other dashboards when they click on buttons . You may consider this workaround. Set the Action of your button as Web URL, and input the dashboard link as the value of it. Then, when they click on the button, they will be brought to related dashboard.

If you would like to filter another dashboard based on the selection in current dashboard, unfortunately, we don’t support this scenario currently. We only support pass filters to report by using parameter in the Report URL, which you can refer to Filter a report using query string parameters in the URL - Power BI | Microsoft Docs.If you really need it, please consider voting for these ideas:

Microsoft Idea · Pass filters in URL (powerbi.com)

Microsoft Idea · Filter whole report/dashboard with one selection (powerbi.com)

Microsoft Idea · Dashboard filters filter drill through report (powerbi.com)

Best Regards,

Community Support Team _ Caiyun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If you still have problems on it, please feel free to let us know. Thanks a lot!

Re: Pre-Filtering The Result Based on User Selection

Milan14 — Sat, 20 Nov 2021 06:29:13 GMT

Hi v-cazheng-msft,

Thanks for your reply. I have tried out with the method you suggested and surprisingly it's works. But currently I'm having an issue which it brought me to a new tab everytime when I click on a different value. May I know is there any way to open the Web URL under the same tab?

Does anyone have any ideas that could help?

Looking forward to your reply.

Thanks in advance!

Kindly Regards,

Milan

Re: Pre-Filtering The Result Based on User Selection

v-cazheng-msft — Mon, 22 Nov 2021 01:38:31 GMT

Hi Milan14

Thanks for your feedback! For Power BI itself, we currently don't provide a method to specify how the Web URL open, but I do see the similar needs in Power BI ideas. You may vote for these ideas here:

Allow Hyperlinks in Text Boxes to Open in Same Tab

Open url in same tab

Best Regards,

Community Support Team _ Caiyun