The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all,
Right now, my power bi is showing
2020 2021
Product 1 Rev cost Rev cost
XX XX XX XX
Product 2 Rev cost Rev cost
But I want it to show
Rev Cost
2020 2021 2020 2021
Product 1 XX XX XX XX
Product 2 XX XX XX XX
Please help. Thank you!
Solved! Go to Solution.
@lkt88888 , Not possible unless you unpivot the revenue and cost
column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
HI @lkt88888,
Did these 'Revenue' and 'Cost' are from different value fields, right?
If that is the case, I think you need to do unpivot column on the fields to convert the to attribute and values, then you can add the attribute field above the year field to show the visual graph as your requirements.
Unpivot columns (Power Query) (microsoft.com)
Regards,
Xiaoxin Sheng
@lkt88888 , Not possible unless you unpivot the revenue and cost
column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
93 | |
88 | |
70 | |
65 |
User | Count |
---|---|
232 | |
128 | |
116 | |
82 | |
82 |