Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I've created two measure (measure=calculate(countrow),conso(cat)="forecast,measure2=calculate(countrow),conso(cat)="Actual") that I've put in a column clustered chart.
Only problem when I try to click on one of the measure for example on the measure 2 in february it selects measure1 also.
My objective is just to click on measure 2 and have the forecast for february display on the tab below my graph
Thanks for your help.
Best regards,
Solved! Go to Solution.
@yanisyes I think what you are looking for is this:
Create only one measure: Measure = COUNTROWS('conso')
On the visual on top put months on the axis and category on labels.
On the matrix below put the months on the rows and category on the columns.
Now, if you will click on the label on the top visual it will only show this category on the matrix below.
Hi @yanisyes ,
According to your description, you may have some misunderstanding about filter, filter is only for rows, cannot filter columns. measure and measure1 are seperate columns in the table, it can't be filtered.
By my test, @SpartaBI 's solution works fine.
I also attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @yanisyes ,
According to your description, you may have some misunderstanding about filter, filter is only for rows, cannot filter columns. measure and measure1 are seperate columns in the table, it can't be filtered.
By my test, @SpartaBI 's solution works fine.
I also attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@yanisyes I think what you are looking for is this:
Create only one measure: Measure = COUNTROWS('conso')
On the visual on top put months on the axis and category on labels.
On the matrix below put the months on the rows and category on the columns.
Now, if you will click on the label on the top visual it will only show this category on the matrix below.
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |