Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a Power BI dashboard with multiple filters - Region, Priority, Portfolio etc.
I've added a title to the page which changes according to Region selected.
example:
default is - x% projects delivered in 2017
If a region is selected: x% projects in <region> delivered in 2017.
The above works fine when no selections are made in other filters.
What I want is to modify my title to included selections in other filters as well:
For example:
x% <priority> projects in <region> delivered in 2017.
The measure I'm using for the title is as follows:
Main_Title1 = IF(HASONEVALUE(DATA[Region]), " projects in " & VALUES(DATA[Region]) & " delivered on time"," projects in ITPS delivered On time")
Any help would be really appreciated.
Thank You,
Parul.
Solved! Go to Solution.
Hi,
I understand that this is basically to keep track of all the selections in the PBI window for easier understanding by somewone who is the end consumer of your report.
To solve it, I add a rectangular box with title 'Selection guide'. WIthin this, I include table with title eg. Region, Subregion, Product. Now, to keep them all just as visual guides, I remove thier interactions with other graphics on the tile.
Hope this helps
Pls refer to the snapshot aboove. It is a set of multiple tables for key attributes one has to keep track of during analysis and presentations. It does consume some space of the window, but some Clients are really choosy about it.
Hi,
I understand that this is basically to keep track of all the selections in the PBI window for easier understanding by somewone who is the end consumer of your report.
To solve it, I add a rectangular box with title 'Selection guide'. WIthin this, I include table with title eg. Region, Subregion, Product. Now, to keep them all just as visual guides, I remove thier interactions with other graphics on the tile.
Hope this helps
Pls refer to the snapshot aboove. It is a set of multiple tables for key attributes one has to keep track of during analysis and presentations. It does consume some space of the window, but some Clients are really choosy about it.
Thank You 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |