Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
There is a client requirement in which in a matrix visual i have to show the distinct count of promotions for which item is sold till now, in a separate columns in matrix visual.But the problem arises as we have Month field pulled in Columns inside a matrix.In rows there is company name and country name.If we pull our measures inside matrix under values then the count is further coming under month hiearcahy which we dont want.We want it as a separate column
Note:1)Comapany and year in rows of matrix
2)Month in columns
3) 11,12,17 ETC IS PROMOTIONS RAN coming from some other measure is dragged under values.
| Company | Year | month | count of promotions | ||||
| april | may | jan | feb | march | |||
| maruti | 2021 | 11 | 12 | 17 | 3=(here distinct count of 11,12,17) | ||
| hyundai | 2022 | 12 | 10 | 2=(here distinct count of 12,10) | |||
| bajaj | 2023 | 10 | 1=(here distinct count of 10) |
Hi I have the same requirement. Did you find a solution for this?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.