Forum Discussion

TLW_STL's avatar
TLW_STL
Helper I
1 year ago
Solved

How To Display Row Header Below Value

Is there a way to display the row header below the value?

 

 

 

I would like something similar to the example below, but I can't find any instructions online.

 

 

Thanks!

  • Deku's avatar
    Deku
    1 year ago

    I think you can with New Card. You can also embed a SVG image in a measure and show the image in the card if you want something more exciting than a emoji ğŸ˜Š

7 Replies

  • Deku's avatar
    Deku
    Super User

    If you use Cards or the New Card Visual then yes the Label can be below the value

    • TLW_STL's avatar
      TLW_STL
      Helper I

      Thank you, Deku, for the response.  If I use a Card or New Card, I do not think I can use conditional formatting for icon and font color, is that correct?  That is why I did not use a Card previously.  Thanks!

      • Deku's avatar
        Deku
        Super User

        I think you can with New Card. You can also embed a SVG image in a measure and show the image in the card if you want something more exciting than a emoji ğŸ˜Š

  • TLW_STL , 

    what type of visual you are using? 
    In card visual it is default to below the value. 

     

    • TLW_STL's avatar
      TLW_STL
      Helper I

      Hi Manikumar34, I specifically need a measure similar to what you show above, but with an up/down arrow that changes color, depending on whether the variance is positive/negative.  I am going to look more into the New Card mentioned above.  Thanks!

      • manikumar34's avatar
        manikumar34
        Solution Sage

        TLW_STL , 
        on the new card you should change the position from Callout Values>Label>Position>Below Value. On the old card visual is default.

        I don't think formatting icons on new card visual is possible. I haven't used it, work around and see if it works. But if you want to do soemthing similar with old visual then you will have create a measure and use that on another card to display the icons. Format and group both the visuals to look like one visual.

         

  • Hi TLW_STL 

     

    It looks like you're using a matrix. Matrix will always display the headers above the values. You can however use a disconnected table to return a value based on row value of a column.

     

     

    Invisible character is used as the column although you can set the color to make it blend with the background.

    Then these measures are added to the matrix

    Rev/Txn = 
    SWITCH (
        SELECTEDVALUE ( 'Custom Matrix'[Sort] ),
        1, [Total Revenue],
        2, [Total Transactions]
    )
    
    Metric Name = 
    SELECTEDVALUE ( 'Custom Matrix'[Category] )
    

    Rev/Txn is then conditionally formatted base on another measure or certain criteria. I used this measure in the image above.

    Rev/Txn vs Previous Month = 
    VAR _prev =
        CALCULATE ( [Rev/Txn], PREVIOUSMONTH ( Dates[Date] ) )
    VAR _diff = [Rev/Txn] - _prev
    RETURN
        DIVIDE ( _diff, _prev )
    

     

    Please see the attached sample pbix.