Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Is it possible to have measures on rows in a matrix?
I know there is an option in format-values and turn on "show on rows"
But what I further want to achieve is for example:
this month last year TYD TYD-1
sales
cost
result
Sales Cost and results are all measures..
Solved! Go to Solution.
Hi @Anonymous ,
I was assuming that those were columns on your data, can you please a sample share, as @amitchandak you need to make a use between switch function and an auxiliary table.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
On the Matrix option find the option SHOW ON ROWS if you activate that, the measure will be shown as you need.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsTnx, I only get one column with the measures.
I need columns for example: last year, TYD and TYD-1
One option is union and summarize
union ( summarize( table[group_by1],table[group_by1],"measure","Sales","MTD",<MTD formula>, "YTD",<Ytd Formul>...),
summarize( table[group_by1],table[group_by1],"measure","Cost","MTD",<MTD formula>, "YTD",<Ytd Formul>...)
...
)
Group, add constant value for measure name and MTD, QTD, YTD, last year etc.
Hi @Anonymous ,
I was assuming that those were columns on your data, can you please a sample share, as @amitchandak you need to make a use between switch function and an auxiliary table.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThere is property "show on row". that can help.
But what you are writing splitting meaures into both row and column
Yes, splitting measures into both row and column.
Possible workaround would be creating a table with measures names and then using switch.
I was hoping there is another quick way.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |