Forum Discussion

deb_power123's avatar
deb_power123
Icon for Helper V rankHelper V
5 years ago
Solved

How to exclude or hide a specific row subtotal in a Table Matrix visualization?

Hi All,   Can someone please suggest me how can I hide or exclude the subtotal of the row highlighted in red below from my table matrix in powerbi?   I just want to show %Occupied[marked in yello...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi deb_power123 ,

    I'm afraid not. Font settings could only formatted in the Format pane and apply to the whole value fields instead of using conditional format.

    If the bold font is necessary, we could only adjust the font size as blod entirely under Values tab.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
5 years ago

Hi deb_power123 ,

Currently we can just set the font color by conditional format. Create a measure like this:

Format =
IF (
    WEEKDAY ( MAX ( 'Table'[Date] ), 2 ) = 6
        || WEEKDAY ( MAX ( 'Table'[Date] ), 2 ) = 7,
    "red"
)

Apply it for the previous two measures in conditional format:

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

deb_power123's avatar
deb_power123
Icon for Helper V rankHelper V
5 years ago

Hi v-yingjl  awesome approach, can I also make bold font along with red color in your above stated forumla? please suggest...

 

Is there a way to make it both red and bold ...so it looks more distict...please suggest 

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi deb_power123 ,

    I'm afraid not. Font settings could only formatted in the Format pane and apply to the whole value fields instead of using conditional format.

    If the bold font is necessary, we could only adjust the font size as blod entirely under Values tab.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • deb_power123's avatar
      deb_power123
      Icon for Helper V rankHelper V
      5 years ago

      Thankyou that worked

    • deb_power123's avatar
      deb_power123
      Icon for Helper V rankHelper V
      5 years ago

      Hi v-yingjl 

       

      I have a table location and I want to hide the total of seats used column[Total Used] and show only total for [%Occupied] .

       

      I am able to do so using the DAX you suggested in above thread but it works correctly only when there are multiple entires of building floor for a location but when it is single location then it is showing both total of seats used column[Total Used] and show only total for [%Occupied].

       

      Below is the DAX to hide the Total Used values in the visual:

       

      Total Used = IF(
      HASONEVALUE( 'location'[seats used]),
      SUM('location'[seats used]) & "|"
      & SUM('location'[seats available]),
      BLANK()


      )

       


      %Occupied = SUM('location'[seats used])/SUM('location'[seats available])

       

      My present visual looks like below :-

      Here I want to get rid or hide the total of Used  which is highlighted in yellow. The DAX query  is only working when there are multiple entries for building floor column corresponding to its location.

       

      Input data :-

       

      Expected output:-

      Could you please suggest how and what changes do i need to implement in the above DAX to hide the total of  used column[highlighted in yellow]?

       

      Input source is same as the above .pbix file you provided.

      kind regards ,

      sameer