Using a base table to dynamically control formatting across pbi paginated reports and now wanting to apply the same to pbi dashboards.
Missing the functionality to conditionally apply font characteristics (size, size offset, font family) to a table/matrix row just like Font Color.
Apply conditional formatting in tables and matrixes <- m$ learn page
power bi table visual font size
Ideas threads to up-vote:
Power BI Desktop - conditional font formatting like font size, font size offset, font family etc
Conditional formatting options
Standardise Font Size Across Visualisations
Fix Font Size in Table and Matrix Visuals
Field Formatting Font size, family, style
Changing font size for a particular field in Matrix
Ability to conditionally format text size/bold just like Background Color and Font Color
Posting the dataset and paginated report code that is working.
dataset - glyph column and associated glyph column attribute columns
paginated report application of glyph column
the running report utilising traffic lights from the common glyph table
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.
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.
Conditional formatting, right mouse menu selected ...
... 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$.
User | Count |
---|---|
135 | |
84 | |
64 | |
57 | |
55 |
User | Count |
---|---|
212 | |
109 | |
88 | |
82 | |
76 |