Forum Discussion
Help Filtering ONLY the Line Graph inside a Line and Clustered Column Chart
I have the above graph that shows total counts of orders for my company then there is a line graph (a simple calculated measure for % of orders that were on-time). The issue is that the percent is averaging for both 2022 and 2023, I would like the line to only show 2023 thus filtering it to only 2023.
Is this possible? If so how?
I have created a separate measure that filters the data for 2023 only and all the caluations look good on a table but when they're brought into the chart its still wrong.
2 Replies
C4nesF4n , Use a slicer with the date column. Selecting slicer in the visualization pane right click on the column and apply date heirarchy to the column. This will give you only years on the slicers with dropdown to further distinction. If the further distinction has to be removed, delete all the other field from the slicer except year.
Thank You
I added the slicer however it filters all fields, so it corrects the issue with the line graph but then you cant see the 2022 bars.
Did I do something wrong?
