Forum Discussion

PBIFanHook7's avatar
PBIFanHook7
Helper III
1 year ago
Solved

How to store Help Text (terms and definitions) into a table visual with proper formatting?

We use a Help Page to describe the items on our reports. We are looking for a better way to present the Help Text. Right now we copy/paste the information (terms/definitions) from a document into a t...
Need Help
PBIFanHook7's avatar
PBIFanHook7
Helper III
1 year ago

One of my other above questions, could I create a Help Report and use the report metadata as a source file? Is there a such thing as a Power BI Report metadata file which contains report column meta data?

Ritaf1983's avatar
Ritaf1983
Super User
1 year ago

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 View

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • PBIFanHook7's avatar
    PBIFanHook7
    Helper III
    1 year ago

    Rita, thanks for your excellent responses to my original question (post) and my secondary question. I am going to look more into the DAX Query View Info Dax Functions. I read the link you sent me. (I had also been informed that I could use the PBI Desktop Dataflow along with the Table and Table.Schema options to get a list of the columns used in the data model. Have you used this method? This method seems a little more complicated than using the DAX Query View Info Fuctions.) 

     

    I may strongly consider just creating an excel data dictionary (like what I shared in my original post), load it into power bi desktop, create a help page with a slicer filter to pull in the report specific columns (and their definitions) from the excel data dictionary, and display these items on the help page. This will have to be done in each power bi report. 

     

    I am new to power bi. So, I really appreciate your guidance, and thanks for your patience and help.