Forum Discussion

emfil9198's avatar
emfil9198
New Member
2 years ago
Solved

Select calculated measures dynamically

Hi everyone, 

 

I wonder if it is possible to determine which calculated measure we want to show in our matrix dynamically (without needing to go into the data panel on the right) I want my boss to be able to click on the measure he wants to appear on the matrix.. 

 

For example I would like him to be able to choose only FOB_CAD and BRUT_CAD to appear in this matrix and all the other columns to hide dynamically 

 

Thanks for your help!

 

Tips and Tricks
  • Wilson_'s avatar
    Wilson_
    2 years ago

    Hi emfil9198,

     

    Sounds like you would benefit from creating field parameters in the data model. Check out this short tutorial youtube video about field parameters.


    ----------------------------------
    If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

     

    P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.

1 Reply

  • Wilson_'s avatar
    Wilson_
    Memorable Member
    2 years ago

    Hi emfil9198,

     

    Sounds like you would benefit from creating field parameters in the data model. Check out this short tutorial youtube video about field parameters.


    ----------------------------------
    If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

     

    P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.