cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
garythomannCoGC
Super User
Super User

Power BI Desktop - conditional font formatting like font size, font size offset, font family etc

2 REPLIES 2
garythomannCoGC
Super User
Super User

Posting the dataset and paginated report code that is working.

 

dataset - glyph column and associated glyph column attribute columns

garythomannCoGC_3-1695622145906.png

 

paginated report application of glyph column

garythomannCoGC_4-1695622271976.png

 

the running report utilising traffic lights from the common glyph table

garythomannCoGC_5-1695622324508.png

 

garythomannCoGC
Super User
Super User

Still 'stop work' on this one.  Conditional formatting of visual columns for properties other than 'colour' still not available.

 

We have a static attribute table of glyphs used throughout our system.  

'CPP Traffic Light Short Status' is the name of the static table that the table below is driven off.

garythomannCoGC_1-1695621223580.png

 

For example the dashboard below has traffic lights setup.  Wanting to replace the problematic image traffix lights (the two larger image columns to the left) with the glyph attribute driven columns.  But programming the font size is the last hurdle due to the missing conditional functionality from pbi desktop.

 

garythomannCoGC_0-1695621012690.png

Conditional formatting, right mouse menu selected ...

garythomannCoGC_2-1695621463228.png

 

... only Background color and Font color changeable attributes available.

 

Note Icons and Web URL will NOT suffice.  Using unicode glyphs gives 'the whole world' of unicode character shapes and not just the very few preset ones chosen by m$.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors