Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
7 | |
6 |