Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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!
Solved! Go to Solution.
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 😊
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.
@TLW_STL ,
what type of visual you are using?
In card visual it is default to below the value.
Proud to be a Super User!
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!
@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.
Proud to be a Super User!
If you use Cards or the New Card Visual then yes the Label can be below the value
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!
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 😊
User | Count |
---|---|
82 | |
72 | |
67 | |
47 | |
36 |
User | Count |
---|---|
111 | |
56 | |
50 | |
42 | |
40 |