Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
6 years ago

DAX 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 calcu...
Need Help
Show and Tell
Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
    o59393
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    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.