Forum Discussion

sarioooo's avatar
sarioooo
Regular Visitor
6 years ago
Solved

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

  • sarioooo's avatar
    sarioooo
    6 years ago

    thank you Josef

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

    Best regards 
    Sarioooo

3 Replies

  • 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's avatar
      sarioooo
      Regular Visitor

      thank you Josef

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

      Best regards 
      Sarioooo