Forum Discussion
Line Chart dill down by slicer select filter
Dear All
I have daily sales data and 4 products data .
now my report display it in line chart axis by date hierarchy ( month , day) , legend by products and value by sales amount
filter by Slicer(month)
how can i do.
if i want select only one month in slicer filter then line chart x axis change to day.
if i want select multi month in slicer then line chart x axis change to month.
and also select all month slicer then line chart x axis change to month.
select multi / all months
select only one month
Thank yous
Sarioooo
Hey sarioooo,
you are using a date hierarchy on your x-axis? If yes - fine 🙂
Unfortunately you would still need to drill down or drill up (by pressing the respective buttons on your visual) since you can't change the drill level by just slicing the whole thing.
BR,
Josef
thank you Josef
I knew about respective buttons . but just want to know the another way can do .
Best regards
Sarioooo
3 Replies
- JosefPrakljacicSolution Sage
Hey sarioooo,
you are using a date hierarchy on your x-axis? If yes - fine 🙂
Unfortunately you would still need to drill down or drill up (by pressing the respective buttons on your visual) since you can't change the drill level by just slicing the whole thing.
BR,
Josef
- sariooooRegular Visitor
thank you Josef
I knew about respective buttons . but just want to know the another way can do .
Best regards
Sarioooo- JosefPrakljacicSolution Sage
Sry sarioooo to dissapoint you here but there are no other ways