The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello everyone, still trying to figure out how to transpose columns to rows. Idea: i want to make months on the top of the table and then Measures to the left. Bendros pajamos....., EUR and bendros pajamos...., metrais are measures.
Is it some how possible?
Solved! Go to Solution.
@Anonymous , You have the option "Switch values to row" in new format pane and show on row in old format pane
Or refer
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
@Anonymous , You have the option "Switch values to row" in new format pane and show on row in old format pane
Or refer
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Thank you very much Amitchandak. Problem was that i from the beggining added rows, and this is why i wasnt able to switch values to rows. But after i deleted it and added after change, everything works fine.
THANK YOU ONCE AGAIN.
User | Count |
---|---|
28 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
12 | |
9 | |
7 |