Solved: measures on rows in matrix

powerbiexpert22 · ‎08-26-2024

i want to show measures on rows of matrix like below , please see below pbix and expected output

pbix:

Jihwan_Kim · ‎08-26-2024

Hi,

I suggest to check the format section -> Values -> Options -> switch values to rows

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Jihwan_Kim · ‎08-26-2024

Hi,

I suggest to check the format section -> Values -> Options -> switch values to rows

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

powerbiexpert22 · ‎08-26-2024

thanks, i am getting incorrect values in total orders , total orders are 13 in 2022 however it shows 8

also one extra column is shown on visual as highlighted beow

please see the pbix file for reference

pbx:

sample data :

powerbiexpert22 · ‎08-27-2024

Thanks alot for your help, it works, I was able to hide the column using exlude from meny after right click and it shows correct values as well

measures on rows in matrix