Forum Discussion
Vishruti
Helper I
Helper IMatrix Visual to Display Columns where Data Does not Exist
I have data (as given below) (also attached in Excel). The data is about Products, Product Type and Quarter-Year. For one product, there may be multiple Product Types for the same quarters or mul...
nandic
Resident Rockstar
Resident RockstarHi Vishruti ,
In data you need to have all expected values.
Example, in sheet "Data" there is no Quarter_Year "Q3_2025" and "Q3_2026".
As it is completelly missing, it can't be shown.
So there are two options:
1. add these columns in Data sheet
2. make data model a little bit more complicated, where you would have disconnected table with all needed values and then using DAX make it work nicely
But for this stage, i suggest the first option.
Cheers,
Nemanja