Forum Discussion
show filter datas based on slicer selection
Hi Jihwan_Kim ,
Thank for your answer.
But I need to show dates as a filter for end user when I selected slicer value.
Also if they select Monthly I need to show month start dates like below.
And If they select any month i need to show the sum of sales for that month (totals days sales in month)
| 1/1/2022 |
| 2/1/2022 |
| 3/1/2022 |
| 4/1/2022 |
| 5/1/2022 |
| 6/1/2022 |
| 7/1/2022 |
| 8/1/2022 |
| 9/1/2022 |
| 10/1/2022 |
Similarly when they selected weekly I need to show last 12 weeks data.
And If they select any week i need to show that week sum of sales
| 9/4/2022 |
| 9/11/2022 |
| 9/18/2022 |
| 9/25/2022 |
| 10/2/2022 |
| 10/9/2022 |
| 10/16/2022 |
| 10/23/2022 |
| 10/30/2022 |
| 11/6/2022 |
Super UserHi,
Thank you for your feedback.
I am not sure whether I understood your question correctly, but please check the attached pbix file if it suits your requirement.
I tried to create FIELD Parameter and connect to the slicer table, like the below.
This field parameter makes Axis dynamic as per the selection of the slicer.