Forum Discussion

WendyDUFE's avatar
WendyDUFE
Icon for Helper III rankHelper III
5 years ago

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 

 

 

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