Dynamic naming of the column designation

[Sebastian]

Hi all,

is there a way to create the designation of a column dinamically?

For example you have a matrix visual and a measure as value. The measure looks like this

Year value = calculate(sum(value);year(date)=year(today())-1)

The designation in the matrix for the measure should be this year 2016 and next year 2017.

Is there still existing a way to create this dynamically based on the  syntax of the measure?

[Anonymous]

HI @Sebastian,

Current power bi not support to use measure as title. I agree with smoupre's point, it may suitable for your requirement.

Perhaps you can try to submit an idea for this requirement.

Regards,

Xiaoxin Sheng

[Sebastian]

Hi @Anonymous, @Greg_Deckler

thanks for your answer. 

I think I will submit this as an idea. 

Regards

Sebastian

[Greg_Deckler · Accepted solution]

You can create a measure like below and put it into a Tile visualization:

CountryTitle = IF(HASONEVALUE(Geography[Country]),"Sales for "&MAX(Geography[Country]),"Sales for All Countries")

The example above puts things like "Sales for All Countries" or "Sales for USA", etc. depending on what is filtered on the page.