Forum Discussion

NJ_hokie's avatar
NJ_hokie
Regular Visitor
1 year ago
Solved

Show custom message when tables are linked but selected value not found

When you select a value in a slicer, if that value is not found in the linked table, how do you show a message (e.g. 'value not found'), instead of it just being blank? Attached image shows all. T...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    NJ_hokie 

    there is a workaround for you. You can create a card beside the table

     

    comments = if (ISBLANK(max(TestScore[Score])),"no value","")
     
     
    pls see the attachment below
  • speedramps's avatar
    speedramps
    1 year ago

    Hi NJ_hokie 

     

    ryan_mayu  has suggested a good idea but it does not work if you select more than one name

     

    Try this method ...

    Right click on Name and select Show items with no data

    another way is create measure with + 0.

    This will always force a value, even when there is nothing

     

    Answer = 
SUM(Scores[Score]) + 0

     

    Please click thumbs up and accept solution. You can accept more than one solution. Thank you !

speedramps's avatar
speedramps
Icon for Super User rankSuper User
1 year ago

Hi NJ_hokie 

Thanks for accepting a solution.

Please can you also accept mine.

You cam accept more than one solution to show you appreciation to helpers.
It was one of the first and works ok.

The [accept solution] points help reflect my competency and your gratitude.

Thank you for your assistance in the matter

 

NJ_hokie's avatar
NJ_hokie
Regular Visitor
1 year ago

I accepted both solutions, which included yours, immediately after my earlier reply. I no longer see an 'accept as solution' after what you wrote, so as far as I can tell I did accept it. I'm new to this forum so if there is something I did not do correctly let me know and I will correct it.