~Creating dynamic titles~
how to create and use basic dynamic titles that change depending on a slicer's selection
What you will need:
- Firstly we will need to create a new measure, once the measure has been created we then want to set dynamic title in our visualization's.
- Select the visualization you want to add the title to
- Go to the format painter
- Select “Title”
- Select the "fx" box under “Title text”
For more information checkout the link below and follow the steps along with detail explanation.
URL: https://blog.coeo.com/power-bi-tips-tricks-creating-dynamic-titles
Example:
SalesByMonthTitle = IF(SELECTEDVALUE(Category[CategoryDescription]) = BLANK(), "Total", SELECTEDVALUE(Category[CategoryDescription])) & " Sales by Month"
沒有留言:
張貼留言