Implementation of MicroStrategy Report Filter into Power BI.

[kanchan_varpe9]

Hi Team,

We want implement the Microstratgy Report Filter into the Power BI.

We have tried the below approuch to achieve the same. However, It's not same as the Microstartgy.

1. Pass Filters Between Reports Using URL Query Strings (Power BI Service only)

2. Cross Report Filtering

In Microstartgy the Report filter is the filter in which directly used in other report as Filter. Attached the screenshots for the reference. Please suggest the Work around or any alternate solution to achieve the same.

Regards,

Kanchan.

[MFelix · Accepted solution]

Hi @kanchan_varpe9 ,

If you want to pass filter trough reports you need to use the cross report drill-trough, check the document below.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through

[Sidhant]

Hi folks,
I was exploring on other functionality which we have in MSTR but not available in Power BI that's Drill across. I have posted a question on the forum as well, and based on some initial response they have pointed out to Field Parameters, which do work in case of tabular reports but in case of non-tabular there's an issue, so if @kanchan_varpe9 , @AnkitaaMishra , @MFelix if you guys help me here it will be quite helpful.
Here is the forum post link: Drill Across in Power BI 
I know I have diverted the thread from the original topic but found this post close to one of the MSTR functionality hence added the comment.

Regards,
Sidhant

[Anonymous]

Hi @kanchan_varpe9,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Please continue using Microsoft community forum.

Thank you,
Pavan.

[Anonymous]

Hi @kanchan_varpe9,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[Anonymous]

Hi @kanchan_varpe9,

Thank you for reaching out in Microsoft Community Forum.

Thank you  @AnkitaaMishra , @MFelix for the helpful responses.

As suggested by AnkitaaMishra,MFelix,  I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.

Please continue using Microsoft community forum.

Regards,
Pavan.

[AnkitaaMishra · Accepted solution]

Hi @kanchan_varpe9 , 
I think this can be achieved using the cross-report drillthrough functionality of Power BI, you can go through below video : https://www.youtube.com/watch?v=OcZr_70OGPo

Thanks,

Ankita

[MFelix · Accepted solution]

Hi @kanchan_varpe9 ,

If you want to pass filter trough reports you need to use the cross report drill-trough, check the document below.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through