Forum Discussion
Dynamic Measures to be change
- 1 year ago
Hello NadeemAhamed ,
so to add of what mentioned, you can add a category for the field parameters to group them with first group and second group.
check this to see how https://youtu.be/qlhcN3A0HNU?si=AAk6UpydnD7vzrZt
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.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
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.
- Idrissshatila1 year agoSuper User
Hello NadeemAhamed ,
so to add of what mentioned, you can add a category for the field parameters to group them with first group and second group.
check this to see how https://youtu.be/qlhcN3A0HNU?si=AAk6UpydnD7vzrZt