Forum Discussion

BernW's avatar
BernW
New Member
5 years ago
Solved

Replacing blank in visual on conditional data

Hi, 

I have a source table similar to the example:

Records      Is good

AABB          True

BBAA          True

CCAA          True

DDAA         False

 

I have a table in my desktop that returns a record against a slicer however I only want the reposnse to come up when the 'Is good' column is true, which i have a acheived through a simple filter on the table. So now when i select 'DDAA' from the slicer, the table is blank. I would prefer the returned result is 'not available; as that's more accurate than what looks like missing data. I can't alter the source data and add extra columns as it's connected to multiple other data models. Is there a way to change the blank to 'not availbale'? As there is data in the column the isblank function doesn't apply. 

Need Help

2 Replies

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    5 years ago

    Hi, BernW 

     

    I tried to reproduce the results mentioned in the above blog, I hope it will be helpful to you.

     

    I created a simple sample. There are no sales for the 2015 year, so there is no data to show.

    1. Create a measure for no data:

    _No data = if(ISBLANK(SUM('financials'[Profit])),"No data for the selected criteria","")

    2. Display it in red font on the card visual. Turn off the category label, the background, visual headers, border etc. to make it just a pure text in the report

    3. Open the selection pane and place the card at the bottom of the bar chart.

    4. Place the card and bar in a group

    Done, this is the final result.

     

    Please refer to the attachment below for details. Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


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