Forum Discussion
Filter dates in X axis dynamically in a column chart based on a date slicer selection
Hi Reddy5833 ,
Thanks for your reply. I can understand your needs now based on your new description. Your measures are actually pretty good, I made a simple sample of data and applied your two measures, and it successfully returned the correct results.
See Entry Date data:
Here's what the filter results for different filters.
According to my reasoning, the reason for the error in measure return on your side is because there is a relationship between your Date Table and the Entry Date, please remove it.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Thanks a lot for you efforts, it shows the right count when you put in the card visual, but when I plot the column chart, it it showing as below.
In the above screenshot, I have selected 3 days from the date range slicer, as per my original requirement if I selct <= 4 dasy it should show last 10 days data that means 10 bars on the bar chart, distinct count by each date for 10 days.
below is the expected output (Considering Sep-9 is the max date available in my fact table)