How to use values that haven't showed up yet

[Anonymous]

Hi

I'm using a daily repopulated table to create a dashboard with several graphics and cards.

Some columns can have specific values but those values haven't showed up yet. For example, column "A" can have rows with values "1","2" and "3". But for now, only values 1 and 2 are showing up on a daily basis.

The problem is I know the value "3" will show up eventually and I want to have Card that tracks the amount of "3" in that column. But since "it doesn't exist" in the current dataset, I can't use it as a filter for that Card.

Is there any way of doing this? Using a specific custom value as a filter for a Card or a graph?

[v-kelly-msft]

Hi @Anonymous ,

So whether will the data eventually show up in the same table or in another table but in the same dataset?If it will show up in the same table,you can directly use the updated column as a filter.

If not,you can go to "edit queries",using "append queries" and "remove duplicates" to keep the new data updated in your column:

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous · Accepted solution]

Hi @Anonymous ,

I am not sure if you want to populate all the possible values in a card visual, those that have data and also no data.

If the values that a column can have is predetermined. That is Column A will have any value between 1 and 3. One possible solution is to create a look up table for column A with values 1,2,3.  Use this table values as a slicer.  Link this table on column A with the data table column A.  In graph visual, use Show Items with no data.

If this is what you expect, try out and feedback.

Cheers

CheenuSing 

[Anonymous]

Thank you, this did the trick