Forum Discussion
Post ProdigyDAX measure not filtering graphs
Hi all
I created a DAX measure to obtain the metric of the on time products. Formula is simple = on time / (on time+not on time)
And a dax to obtain the not on time which basically is a calculate and filter the not on time.
The numbers are correct within the graph. However when i click on that graph the contains these 2 dax, the other graphs that I have in my dashboard do not work.
So, when I click on (1) of upper graph, the rest wont do anything (lower graphs)
These are the dax I created:
4 Replies
- amitchandak
Super User
If possible please share a sample pbix file after removing sensitive information.
Thanks- o59393
Sure!
Here is the file, now the lower graphs update. The problem is when you click on the bar chart of not on time of the upper chart.
For example in the pbi, in 2019 I had 105 not on time. If i click on that, it wont update the 105 registers in the lower chart. It will return all the 2019 values.
Do you know how i can fix that?
thanks a mill!
- Icey
Community Support
Hi o59393 ,
In your scenario, when you click on the part of "not on time" in 2019, Power BI defaults you to choose the year 2019, not "not on time in 2019". Because the "Column series" is blank.
In your scenario, I suggest you to put "Tracking Index" in "Legend" of the other two Stacked bar charts.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- o59393
hi Icey
Thanks for the help. Including the tracking index to the graphs is not the visual we are looking for.
It is just basically be able to filter the not on time when you click on these. I tried adding the on time metric to the column series but it didnt work.
Thanks.
