How to stop text fields from showing any text value when "All" is selected?

[som_mukherjee]

Hello,

I am currently working on a dashboard that displays data on the number of people in Africa who require medication for different diseases. In addition to this data, the dashboard also has a list of key contacts for each country in Africa.

However, I have encountered an issue where selecting the "All" option for the overall numbers updates the text section with the first filled text, which is for country A (Algeria). I would like to know if it is possible to edit the dashboard so that when "All" is selected, the text section displays as (Blank) instead of the first country (Algeria).
Thanks!

[qqqqqwwwweeerrr · Accepted solution]

Hi @som_mukherjee 

If am correct when you select all in filter then it should appear blank here is my solution.

You have to creaet two measure as per your dataset.

Amount Filtered = IF ( [check slection] = 0," ",SUM('input data'[Value]) )

check slection = int(CALCULATE ( ISFILTERED ( 'input data'[Name ] ), ALLSELECTED ( 'input data' ) ))

if something is seleceted in filter

if i select all in the filter than your visual should like that 

just make sure what exactly you need it should be in this measure 

Amount Filtered = IF ( [check slection] = 0," ",SUM('input data'[Value]) ) you can play around as per you business need.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

If it does not help, please provide more details.

Best Regards

[Anonymous · Accepted solution]

Hi @som_mukherjee 

For your question, here is the method I provided:

Here's some dummy data

"Table"

You can create measures, display the data by querying whether to select a slicer. And here is the result

Measure = 
    IF(
        ISFILTERED('Table'[Country]),
        VALUES('Table'[Country]),
        BLANK()
    )

Measure 2 = 
    IF(
        ISFILTERED('Table'[Country]), 
        SUM('Table'[number]), 
        BLANK()
    )

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

Regards,

Nono Chen

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

[qqqqqwwwweeerrr · Accepted solution]

Hi @som_mukherjee 

If am correct when you select all in filter then it should appear blank here is my solution.

You have to creaet two measure as per your dataset.

Amount Filtered = IF ( [check slection] = 0," ",SUM('input data'[Value]) )

check slection = int(CALCULATE ( ISFILTERED ( 'input data'[Name ] ), ALLSELECTED ( 'input data' ) ))

if something is seleceted in filter

if i select all in the filter than your visual should like that 

just make sure what exactly you need it should be in this measure 

Amount Filtered = IF ( [check slection] = 0," ",SUM('input data'[Value]) ) you can play around as per you business need.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

If it does not help, please provide more details.

Best Regards