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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
garythomannCoGC
Impactful Individual
Impactful Individual
3 REPLIES 3
garythomannCoGC
Impactful Individual
Impactful Individual

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
Impactful Individual
Impactful Individual

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$.

Note Cambria font change to the table visual was the best solution so far that gives us the best font size for the glyph characters.  Next is to emulate the table visual in deneb custom visual for full html control.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.