Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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.
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.
User | Count |
---|---|
92 | |
86 | |
66 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |