Forum Discussion

Vishruti's avatar
Vishruti
Helper I
10 months ago

Matrix 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...
Show and Tell
Rupak_bi's avatar
Rupak_bi
Super User
10 months ago

Hi Vishruti ,

You need to make a master quarter table with all quarter names. here is your expected result below. attaching PBIX for referance.