Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
2 years ago
Solved

measures on rows in matrix

i want to show  measures on rows of matrix like below , please see below pbix and expected output  pbix: https://drive.google.com/file/d/19Syc34QUCLEK426p5UWUg87yAKRbWjyR/view?usp=drive_link   ...
Need Help
powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
2 years ago

Hi Jihwan_Kim ,

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:

https://drive.google.com/file/d/1F0SFtxnXtRAFtWvF7HI4zWz3QTXp5P0e/view?usp=drive_link

 

sample data :

https://docs.google.com/spreadsheets/d/1mwSepceO-PwwSPnkJ_a7wIlYKvtb8OCX/edit?usp=drive_link&ouid=107010240500343952141&rtpof=true&sd=true

 

 

 

 

 

  • powerbiexpert22's avatar
    powerbiexpert22
    Icon for Impactful Individual rankImpactful Individual
    2 years ago

    Hi Jihwan_Kim 

    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