Dynamic Commentary in PowerBI

[parulagarwal]

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.

[san_jois · Accepted 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

[san_jois · Accepted 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

[san_jois · Accepted solution]

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.

[parulagarwal]

Thank You 🙂