Forum Discussion

ranaji77's avatar
ranaji77
Regular Visitor
6 years ago

Matrix help

I am trying to recreate an SSRS Matrix in Power BI.   You can see below (SSRS result exported to excel) I have Persons' name, Total No. of Suites by person and Sq. Ft. (sum of sq. ft.) as columns a...
Need Help
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi ranaji77 ,

 

We can try to show the suits number only in the grand total as a workaround, and hide the value when it does not blank by reducing the width size.  Blank() is used to prevent eight from  increasing  when reduce the widthe.

 

SutisMeasure = IF(ISINSCOPE('Table'[ProdCategDesc]),BLANK(),SUM('Table'[Suits]))

 

 


Best regards,

ranaji77's avatar
ranaji77
Regular Visitor
6 years ago

I will give it a try, not sure if thats what i want but i will see how it looks visually and obviously numbers wise.

 

Thanks

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi ranaji77 ,

     

    How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


    Best regards,

     

    • ranaji77's avatar
      ranaji77
      Regular Visitor
      6 years ago

      management didnt like the idea, so we will keep this report in SSRS for now.