Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
thank you Josef
I knew about respective buttons . but just want to know the another way can do .
Best regards
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |