Forum Discussion
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!
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
- DekuSuper User
If you use Cards or the New Card Visual then yes the Label can be below the value
- TLW_STLHelper 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!
- DekuSuper 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 😊
- manikumar34Solution Sage
- TLW_STLHelper 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!
- manikumar34Solution 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.
- danextianSuper User
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.