Column Chart Title Conditional Formatting with DAX Expression

[AfonsoDiTazem]

Hello,

I have a table with Country Names then I have a line and stacked column chart. When I select a country name from the table (is not a slicer) I want the chart name to change accordingly.

I came up with this 2 DAX expression

IsCountrySelected = IF(HASONEVALUE(CountryTable[CountryName]), "Country Selected", "No Country Selected1")

SelectedCountryString = IF([IsCountrySelected] = "Country Selected", "The selected country is " & VALUES(CountryTable[CountryName]), "No country is selected2")

For trial and error I inserted a card with the SelectedCountryString the card updates and works properly however the chart name doesn't.

If I use a slicer with the country names the chart name updates but the card doesn't.

In both cases I'm using the same measure for the chart name and for the card (SelectedCountryString)

Thanks!

[v-jingzhang]

Hi @AfonsoDiTazem 

You may try a single measure as below. It doesn't have this problem. 

Title = IF(HASONEVALUE(CountryTable[CountryName]),"The selected country is " & VALUES(CountryTable[CountryName]),"No country selected")

Notice that the data in my sample is from the same table. If your data are from different tables, please check the relationship between tables. This may lead to different results.  

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[AfonsoDiTazem]

Hello,

Thanks for the reply.

I had already tried that measure and still doesn't work.
Yes, the data is in different tables without a direct connection between them. There a table in the midle connecting the other two

[v-jingzhang]

Hi @AfonsoDiTazem 

Did you use CountryTable's CountryName column in both the slicer and the table visual? Currently, the cross-filter direction of relationship between CountryTable and the middle table is Both, try changing it into Single. In addition, if possible, change the relationship between the middle table and the "Origenes Articulos" table to Single direction too (the middle table filters "Origenes Articulos"). 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.