Forum Discussion

NadeemAhamed's avatar
NadeemAhamed
Icon for Helper V rankHelper V
1 year ago
Solved

Dynamic Measures to be change

Hi Everyone.

 

I have one matrix with multiple measures such as Apr,May...Mar, First Half, Second Half,Final

In my matrix i want to show only first half data means Apr - Oct when if month slicer is till Oct, if month change to Nov i need to show the data from from Nov - Mar it is possible to change the measures dynamically 

 

This is my measures ex: 

PV_Apr =
SWITCH(TRUE(),SELECTEDVALUE('Sheet1 (2)'[Plan/Actual])="rate(%)w.r.t. Plan", FORMAT(CALCULATE(SUM('Sheet1 (2)'[Apr])),"##.0%"),CALCULATE(SUM('Sheet1 (2)'[Apr])))
 

 

for any query/question kindly let me know

Need Help

4 Replies

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

    Hi NadeemAhamed ,

    If I understood correctly, each column in your matrix is a separate measure. In that case, I suggest you try using Field Parameters with groups.

    Here's a helpful video guide
    Field Parameters in Power BI

    If it is something else 

    Please provide a workable sample data and your expected result from that. It is hard to figure out what you want to achieve from the description alone.  

    https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

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

    • NadeemAhamed's avatar
      NadeemAhamed
      Icon for Helper V rankHelper V
      1 year ago

      Thank You Ritaf1983  for your reply

       

      Your understanding is correct we are using separate measures for the all months

       

      I need to do is to show the month data like in two separate groups 

      1st group is Apr-Sep if user is selected till sep

      2nd group is Oct-Mar if user is selected from oct-mar

       

      i just want to understand that is it possible to change the above measures to display such as group data by using the below excel table data. 

       

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi NadeemAhamed 

    Did the solution Idrissshatila  and Ritaf1983  offered help you solve the problem, if them helps,you can condier to accept them as solutions so that more user can refer to.

     

    Best Regards!

    Yolo Zhu