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.
I can't filter the dates on my x-axis... my Date Table has all dates from 1/1/2019 to 12/31/2019. I have data for sales this year, but December keeps showing up in my x-axis, even when filtering by "relative last 12 months." The only way to get rid of December is draggin Date - Month to the filter and taking off December. Know why this could be the case? The data filters if I change the date, but the actual axis still shows the full year dates for the x-axis.
Do you have a relationship defined between date and sales table? If so, try the filtering to both direction.
If this helps,accept it as a solution.
Kudos are good too.
That still didn't work. See screenshots below.
Hi @Anonymous can you upload a snapshot of your chart or data model?
See attached. creating a "both" filter didn't work.
I tested this and it works as expected for me.
I created a Date table with DAX.
TransDate | Value |
01/31/2019 | 100 |
02/28/2019 | 200 |
03/31/2019 | 300 |
04/30/2019 | 400 |
05/31/2019 | 500 |
06/30/2019 | 600 |
07/31/2019 | 700 |
08/30/2019 | 800 |
09/30/2019 | 900 |
10/30/2019 | 1000 |
6/26/2019 | -800 |
10/1/2019 | -400 |
1/31/2019 | 150 |
I figured out my problem. On one of the measures if there were no costs (to calc profit) it said If blank, then 0, or "value" .... the 0 was making a placeholder in the date axis. so I changed that to if blank then blank otherwise the value!
Sorry for confusion. The zero value was adding the other months!
How do I just share a sample of the data? I have measures that might be affecting this probably?
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 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |