The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have multiple tables/visualizations in a page created in powerBI. I want to give title/heading for each of the table, some times the title may be dynamic showing some dynamic value along with static text.
I saw a Text box option in the Ribbon, is that the correct choice?
One approach i followed to show dynamic title is i have created a new measure in the table as shown below and created a visualization card to show the heading for the table, on the card the title is shown but it is displaying the measure name too (HeaderMsg) :
HeaderMsg = "SALES AMOUNT AS ON " & FORMAT(MIN('SALES'[SOLDDate]), "mmmm dd, yyyy hh:mm AM/PM") & " TO " & FORMAT(MAX('SALES'[SOLDDate]), "mmmm dd, yyyy hh:mm AM/PM")
I saw an option Title in the Format section which we can turn on , but when i have a border On for the table, the title text given is shown inside the table border , i want to display out side the border of the visualization and with this option dynamic titles are not possible.
Which is the best approach to give table/visualization headings(static/dynamic)..
Solved! Go to Solution.
Here is the answer, if anyone looking for it:
Create a new measure in the table as shown below and created a visualization card and drag the measure field on the card to show the heading for the table, on the card the title is shown.Turn the Category label off to not to show the column header on the card created to show the title.
HeaderMsg = "SALES AMOUNT AS ON " & FORMAT(MIN('SALES'[SOLDDate]), "mmmm dd, yyyy hh:mm AM/PM") & " TO " & FORMAT(MAX('SALES'[SOLDDate]), "mmmm dd, yyyy hh:mm AM/PM")
Here is the answer, if anyone looking for it:
Create a new measure in the table as shown below and created a visualization card and drag the measure field on the card to show the heading for the table, on the card the title is shown.Turn the Category label off to not to show the column header on the card created to show the title.
HeaderMsg = "SALES AMOUNT AS ON " & FORMAT(MIN('SALES'[SOLDDate]), "mmmm dd, yyyy hh:mm AM/PM") & " TO " & FORMAT(MAX('SALES'[SOLDDate]), "mmmm dd, yyyy hh:mm AM/PM")