Hello EDNA Form Good Day!
What I’m trying to accomplish:
Per the attached sample .pbix, I’m looking for dax measures or another method, that will group like measures together for comparison, instead of what I currently have the measures are within each year.
Per each Sector I would like to see PY$ 2022 and PY$ 2023 next to each other - so on and so forth
Please advise of any questions, much appreciate your time!
Thank you
Sample Data Measures for CY_PY.pbix (105.5 KB)
@ambidextrousmentally That’s not possible, Visuals are built internally by the Power BI Engine by joining the Rows and Columns based on an Index, currently there is not way to modify this.
@AntrikshSharma is correct, this is not possible natively in Power BI.
however, there is a trick that will get the result I think you are looking for.
You need to create a Map table for your Matrix
and this measure to use to populate the table:
Aggregated Measure =
VAR _Selection = SELECTEDVALUE( TableMap[Hierarchy] )
RETURN
SWITCH( TRUE(),
_Selection = "PY$", [PY$],
_Selection = "Lost $", [Amount Lost],
_Selection = "Retention", [Retention] )
Then build your matrix with the Hierarchy column from the Table Map, and the new Aggregated Measure amount.
updated file is attached
eDNA Solution - Sample Data Measures for CY_PY.pbix (109.8 KB)
Hello Heather
This is exactly what I’m looking for a workaround to get the visual I need.
I will give it a try.
Much appreciate your help!
Thank you
Hello @ambidextrousmentally
Did the responses above help solve your query?
If not, can you let us know where you’re stuck and what additional assistance you need?
If it did, please mark the answer as the SOLUTION.
Thank you
Hello @ambidextrousmentally
Just following up if the response above helps you solve your inquiry.
If it did, please mark his answer as the SOLUTION.
We’ve noticed that no response was received from you on the post above. If there won’t be any activity in the next few days, we’ll tag this post as Solved.
Due to inactivity, a response on this post has been tagged as “Solution”.
If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.
We request you to kindly take time to answer the Enterprise DNA Forum User Experience Survey,.
We hope you’ll give your insights on how we can further improve the Support forum. Thanks!