Forum Discussion
METRIC in one column
Hey guys,
can you please explain how to stack all measures into one column (Metric). Each measure is unique. I posted the sample table, where you can see days, %, $. I know how to set %, $ signs, but how can I put all measures into one column, especially measures are grouped by region, manager, company. ( note: screenshots are not mine, but I have very similar situation). Thank you
1 Reply
- amitchandak
Super User
Zafar06 , Switch Value to Row is an option in Matrix
Switch values to row - https://youtu.be/cN8AO3_vmlY?t=11650
Also, seem like Measure is broken into two part, calculation groups can help
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
You can create them from Power BI Desktop
Learn Power BI: Model explorer public preview with calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU
