Well-organized Dynamic Title in Power BI
Many times we have to change the title of tiles according to the selected value from slicer. However when we select more than 3 values and show all the values in the title, the title becomes clumsy. And as a Power BI developer, we want our dashboard to look perfectly good. Then why to adjust with an artless title when we have a key to this problem!
Let’s assume we have an Order table with 3 columns — Order Date, Item, Total Cost.
Now, we will display the Profit according to product and yes, with the dynamic title.
To find out the profit of each item, we have used one simple measure using sum:
At this moment,we have to create one another measure as below for well kept dynamic title :
Now, we are ready to display data with the neat dynamic title.
Hoorah !! Here is the neat and tidy dynamic title.
Please let me know if you have any queries or suggestions in the comments.
Happy DAX-ting!