Forum Discussion

Sidhant's avatar
Sidhant
Icon for Advocate V rankAdvocate V
1 year ago
Solved

Is "Drill Across" Functionality (as in MicroStrategy) Possible in Power BI?

Hi everyone, I wanted to check the feasibility of a feature I’ve seen in MicroStrategy (MSTR) called "Drill Across" — and whether something similar is possible in Power BI, either natively or throug...
Need Help
  • Sidhant's avatar
    Sidhant
    1 year ago

    Hi v-venuppu,
    Probably there are no more questions but there were certain approaches that I have discussed with MFelix which me and my team are trying to look into, so maybe by the end of this week if there are no further queries we can close that, will keep you posted.

    Regards,
    Sidhant. 

v-venuppu's avatar
v-venuppu
Icon for Community Support rankCommunity Support
1 year ago

Hi Sidhant ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you Ritaf1983 for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

  • Sidhant's avatar
    Sidhant
    Icon for Advocate V rankAdvocate V
    1 year ago

    Hi v-venuppu ,
    I did get some clarity that the Drill-Across is not to be implemented as exact copy what we have in 'MSTR'. So based on that I did try to implement a simple Field Parameter and posted it as comment to see whether it was right or wrong, to which Ritaf1983 did clarify that was right & did share some resources (videos on Field params).
    So I had some follow up questions: Do field parameters only work in case of tabular reports, for the ones with cross which are crosstab like or have some formatting.
    Because some of my colleagues did experiment with this and they faced issues with respect to non-tabular reports, to be specific: field parameters work well for tabular reports but the challenge is with matrix reports and pivot style reports.

    Regards,
    Sidhant.

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      1 year ago

      Hi Sidhant 

       

      Field parameters do not play nice with matrix specially when you get the field parameters in both the columns/rows and values, you will get a duplication of the value for each column. If you are using the values to be only columns or rows they will work fine but if you want to use them has values also, for example for measures with groupings you need to be carefull.

       

      • Sidhant's avatar
        Sidhant
        Icon for Advocate V rankAdvocate V
        1 year ago

        Hi MFelix ,
        Okay, I have posted a new reply can you just have a look at it wherein I have mentioned the current approach and some challenges. Also if you have any approaches  that can help in achieving the required functionality (shared in the main thread/post) please do share it will help.
        Also Ritaf1983 & v-venuppu  if you have anything to add please do let me know (you can refer the main thread/post wherein you come to know the requirement {which you already have an idea} and my latest reply wherein I have mentioned the workaround as well as the challenges.

        Regards,
        Sidhant.

    • Ritaf1983's avatar
      Ritaf1983
      Icon for Super User rankSuper User
      1 year ago

      Hi Sidhant 
      Field parametrs work with all kind of visualizations.

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