Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |