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 have a matrix table Ilike below:
Company 1 Company2
2021 2022 2021 2022
MEASURE1 x% x% x% x%
MEASURE2 x% x% x% x%
MEASURE3 x% x% x% x%
And I wish to add a variance column so the table will become like:
Company 1 Company2
2021 2022 YoY Var 2021 2022 YoY Var
MEASURE1 x% x% y% x% x% y%
MEASURE2 x% x% y% x% x% y%
MEASURE3 x% x% y% x% x% y%
Is this possible? I know a Measure can not be shown in Column so can't think of any way to create this variance column.
I'm thinking to convert these measures into a column (i.e. each measure becomes a row of this column), not sure if it's possible via DAX?
Thank you in advance!
Hi @ressul ,
Could you please provide the formulas about measures so that I can convert it to column form for you.
If it is possible, please provide your pbix file without privacy inforamtion and desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi:
They have changed some formatting options. If you go to "Values" you can accomplish mesures on row. Please see image. Thanks..
Hi @ressul
you can use the columns subtotal to disply this value by editing the code of the same measures
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 |
---|---|
41 | |
19 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |