issue in checking condition for header in pie diagram

[dats]

Dear all,

I have an issue with the conditionl formatting of a header in a pie chart.

Date	Agegroup	datasource	Customer
01.07.20	none	old	1
01.07.20	none	old	1
01.07.20	none	old	1
05.07.20	18-25	new	1
15.07.20	18-25	new	1
30.07.20	25+	new	1

The pie chart simply shows the distribution of each agegroup. One for 25+, two for 18-25 and 3 for none. Through "Filter on this visual I am filtering out "none" since I don't want to see the amount of the agegroup none in my chart.

I want the header to be condiationally formated so that the title for the diagram is "AGE*" when the customer has data from the old and new datasource (01-07-30.07) and only "AGE" if  only data from the new datsource is selected.

my dax currently looks like this

IF(CALCULATE(COUNTROWS('Data'),FILTER('Data','Data'[datasource]="old"))>=1,"AGE*","AGE")

The issue here is that within the diagram I am filtering out "none" values but I would still like the header to have the extension "*" as the user has slected a timeframe that contains both data from the old and from the new source.

How do I change my dax formular so that it evaluates the values in the column datasource and ignoring the filter on the visual?

[V-lianl-msft]

Hi @dats ,

Is this problem sloved?
If not, please let me know.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dats]

so the actual question here would be how can I "deactivate" the filter on the AGE for the dax formular but keep it active in the cisual so "none" does not appear

[VijayP]

@dats  In the above example there is no such "none" Data 

[dats]

@VijayP thanks for the answer

lets say the user chooses a timeframe between 01.07 and 30.07 and a customer "1". Then for this customer in general there is data from the old and the new source. In this case I woul like the header to have the extension "*" even if the pie chart does not show the value none

[VijayP]

@dats 

Then   The function should be 
Title = IF(SELECTEDVALUE('Table'[datasource])="Old","AGE",
            IF(SELECTEDVALUE('Table'[datasource])="*","A*"))

[dats]

I think it doenst realy solve the issue since "none" is filtered out in the filsual filter.

This is would I woul like to achieve in the end. I dont know how to tell the dax formular for the header to not include the filtering made in "filter on this visual"

User selection	header
01.07-30.07	AGE*
05.07.-30-07	AGE
01.07.-01.07	AGE*

[VijayP]

@dats 

I think you cannot customise the Column Headers but only the Title of the Table

[dats]

sorry yes this was just an example of outcomes of different combinations. The title would be either AGE or AGE*

[V-lianl-msft]

Hi @dats ,

It should be clarified that if you apply a filter at the visual level, it will affect the current line content of measure. That is to say, when you customize the title, only display the corresponding measure after filtering.

The alternative is to create a nested visual. Set the table title to empty and set the transparency of this visual, and then create a card visual and turn off category label to place in the table title position.

Sample .pbix

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VijayP]

@dats  Try using this Formula

Title = IF(SELECTEDVALUE('Table'[datasource])="Old","AGE","A*")

use his file https://drive.google.com/file/d/1_9-NBXrjyKMkyRjJLtMUGFo_3-Vr_WOq/view?usp=sharing

Please Share your Kudoes