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 all,
I need your help, i have those tabel as below and I want to show them in one stacked column visual which included monthly view of Target and actual ( in two seperate column next eachother in each month) and with category ( as legend for both).
Can anyone hele me?
@Archie-gh , two way.
1. Unpivot Actual and Target, which will bring them in rows and you can have desired visual
2. Create a Sum measure on both. And create a calculation group. calculation group will convert the measure to dimension again you can use it visually on the axis
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Hi Amit,
1. Unpivot doesn't make what I need, becasue it add one more category which is ( actual adn Target). I need to show them in one visual with one category, actual and atarget must be shown in columns. the second solution, was showoing the tabel presentation only, and also it needs one Add in which I don't have it
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |