Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am securing some help here.
There is a visual required in my report, it needs
1) to show two calculated measures' value in two rows - budget and actual
2)The value font value needs to be conditional changed according to the value of another set of calculated measure - if actual is over budget, then shows as red color
3)The value should be aligned to the right of the visual , so that it is easier to make a clue which amount is larger, and how larger it is
something like above
--------- ------------
Based on above, I have tried to use two card visuals (the pbix standard one, not the advance card visual from the app store).
Each visual show one calculated measure value, and put them one by one in horizontal, and grouped them, so they appears to be like they are from the same visual
1 & 2 can perfectly fit in, but 3 can not do.
--------- ---------
I also tried the matrix table, to have each table displayed one measure, but the column header can not be configured as hide, which leads the two matrix table can not be too closer like two rows in one visual.
Any advise if there is any other alternatives to make it ?
Hi @WendyDUFE ,
How about using a multi-card visual shown as below:
You could check the reference via below link:
https://www.tutorialgateway.org/format-power-bi-multi-row-card/
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Thanks @v-kelly-msft
I just tried the multiple cards, but unfortunately, there is no conditional format option to change the font color, also the alignment of the measure value is not configurable.
@WendyDUFE , based on what I got. you can create a color measure and use that in conditional formatting using field value option
if([actual] >[budget] , "red", "green")
refer for steps
my video : https://www.youtube.com/watch?v=RqBb5eBf_I4
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
@amitchandak thanks, the conditional format is fine, the alignment is the issue to be resolved.
Any idea on this ? How to align the card visual to right ?