Forum Discussion
Helper IIIHow to store Help Text (terms and definitions) into a table visual with proper formatting?
Hi PBIFanHook7
If i understand you correctly you can use Dax qauery view >> funiction info.columns joined to info.table
please refer to the linked blog post :
https://powerbi.microsoft.com/en-us/blog/dax-query-view-introduces-new-info-dax-functions/
Zoe Douglas walks through the exact DAX query needed and shows how it works in practice using the DAX Query ViewIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Super UserHi PBIFanHook7
To get the level of formatting you're aiming for (bold section headers, clean grouping, readable layout) — a Matrix visual is a better fit than a standard table.
-
It supports expand/collapse per category (Overview, Purpose, etc.), so users can focus only on relevant parts and collapse the rest.
-
Lets you build a hierarchical structure with
Categoryas the row andDefinitionas the value — no need for fake blank rows or SWITCH logic. -
Much more flexible styling: indentation, padding, font control, and background colors can all be customized.
-
Easier to maintain – just add rows to your source table. No extra calculated columns or logic needed.
Layout examples :
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Helper IIIRita, thank you for your reply. It sounds very helpful. Please give me another day or so to look at it in more detail, then I will probably mark it as a the solution. Thanks again!