Reg: selected month should display in matrix table

[Anonymous]

Hi everyone.need help.please check the attached image,if i select particular then that month should display,if i select multiple months then those months should display and remaining months should ot be visible.

[Icey · Accepted solution]

Hi @Anonymous ,

What is the structure of your data? I guess it may be like "Table 1". If so, please try to select "Product" column and UnPivot other columns, to transform to "Table 2".

Table 1:

Product	Jan	Feb	Mar	...
Product1	123	234	345	...
Product2	123	234	345	...
...	...	...	...	...

Table 2:

Product	Attribute	Value
Product1	Jan	123
Product1	Feb	234
Product1	Mar	345
...	...	...
Product2	Jan	123
Product2	Feb	234
Product2	Mar	345
...	...	...

Then, rename the columns from "Attribute" to "Month" and "Close and Apply".

In Data view, it is suggested to create a Date dimension table and then create relationships between your fact table and the Date dimension table. Of course, you can also not create a date table if your model is simple and you don't want to create one.

After that, just one measure is needed to create and it can also be filtered by the Month column. Also, the result will be what you want.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.