Creating a visual using several filters

[MercedesAlpha1]

Hi

Im trying to create a table or stacked bar chart which shows data for multiple criteria.

So as an example i have a dataset which has numerous contracts and some data is missing in various columns so i wish to create a visual or table which shows the number of missing entries by owner.

However when i apply different filters for each criteria i only see some of them. E.g if i filter on no value added and no title it would show me the number which are missing both when i actually want the number of no title and the number of no values in the same table / visual

Hope that makes sense

[v-tsaipranay]

Hi @MercedesAlpha1 ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

Thank you.

[v-tsaipranay]

Hi @MercedesAlpha1 ,

I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.

Thank you.

[v-tsaipranay]

Hi @MercedesAlpha1 ,

Thank you for reaching out to the Microsoft fabric community forum.

The behavior you are seeing is expected because applying multiple filters on missing values works as an intersection, so only records where all selected fields are blank are returned.

To achieve your requirement of showing individual missing counts per column for each owner within one visual, you will need to create row-level indicators (calculated columns or measures) for each missing field and then use those fields in your visual. This enables independent aggregation instead of intersection filtering.

If you can provide a small sample dataset, we can validate the model and share the exact DAX pattern aligned to your structure.

Also thank you @nielsvdc and @PhilipTreacy  for you response.

Thank you.

[PhilipTreacy]

Hi @MercedesAlpha1 

Please provide some sample data and show the desired result.

It's impossible to know from your description how your data looks so any answer you receive will certainly need modificartion before it works for you.

You say you have contract data - is there only 1 owner per contract?  Multiple owners?  Can a single owner own more than one contract?  How many columns do you have?  Can they all be missing data or just some of them?

When you apply filters what values do you want to see on screen?

Regards

Phil

[nielsvdc · Accepted solution]

Hi @MercedesAlpha1,

You might want to create a calculated column named IsMissingData in the table, that checks rows for missing column data. The calculated column checks every required column for missing values. If any required column is missing data, you can set the column value to TRUE. You can use this column to show any rows with missing data.

IsMissingData =
VAR colA = IF(ISBLANK([Column A]), TRUE, FALSE)
VAR colB = IF(ISBLANK([Column B]), TRUE, FALSE)
VAR colC = IF(ISBLANK([Column C]), TRUE, FALSE)

RETURN
  AND(AND(colA, colB), colC)

You can also create a create a calculated column named NumberOfColumnsMissingData in the table, that counts the number of required columns that are missing data.

NumberOfColumnsMissingData = 
VAR colA = IF(ISBLANK([Column A]), 1, 0)
VAR colB = IF(ISBLANK([Column B]), 1, 0)
VAR colC = IF(ISBLANK([Column C]), 1, 0)

RETURN
  colA+colB+colC

Hope this helps. If so, please give a Kudos 👍 and mark as Accepted Solution ✔️.