Line Chart dill down by slicer select filter

[sarioooo]

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

[JosefPrakljacic · Accepted solution]

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

[JosefPrakljacic · Accepted solution]

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

[sarioooo · Accepted solution]

thank you Josef

        I knew about  respective buttons . but just want to know the another way can do .

Best regards 
Sarioooo

[JosefPrakljacic]

Sry @sarioooo to dissapoint you here but there are no other ways