Forum Discussion

JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

How to display only Total column on the Matrix

I am sharing my Pbix file here.

 

I am trying to only display the Total (renamed to "Variance") column of Variance visual (Matrix).

I was able to delete other columns, and now outstanding issue is the Row column data (in red box) is still shown - on the Variance Matrix.

 

 

Variance Matrix:

If deleting the Rows data is not possible, how do I put the Variance visual go underneath the Today's visual (so it would possibly hide the Rows data)? 

Is there anything like "Layer" for visuals in Pbix?

 

Thanks for feedback / help.

 

 

 

 

 

  • I was able to do it by layer - putting left Matrix over right Matrix. I am not sure if there is other way.

3 Replies

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support

    Hi, JustinDoh1 

     

    Can you provide the data of "vw_daily_priorday" table? The data table displayed by today's matrix also needs to be provided.

     

    Looking forward to your reply, thank you.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • JustinDoh1's avatar
      JustinDoh1
      Icon for Post Prodigy rankPost Prodigy

      v-zhangti Thank you for your help. Actually, I modified the original post, and am sharing my Pbix file. I was able to make some changes (deleting Columns) over last few days, and outstanding issues is explained on the updated post. Thank you so much for help!

  • I was able to do it by layer - putting left Matrix over right Matrix. I am not sure if there is other way.