Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
WendyDUFE
Helper III
Helper III

Visual can config the alignment to right, value conditional format

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 

 

WendyNHK_0-1619509226668.png

 

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 ? 

4 REPLIES 4
v-kelly-msft
Community Support
Community Support

Hi  @WendyDUFE ,

 

How about using a multi-card visual shown as below:

v-kelly-msft_0-1619682386226.png

 

 

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. 

 

amitchandak
Super User
Super User

@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 ? 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.