Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I created two measures which contain : the date of the day and the date of x days before today (x chosen with a slicer).
I would like to plot a graph with some dates on x-axis and numeric values on y-axis.
Do you have an idea how could I filter my axis between my two dates measures ?
Thanks in advance for your help and your time
Solved! Go to Solution.
@maxduff59 if you will create a measure like:
MEASURE =
VAR _x_days_before_date = [Your Date x days before Measure]
VAR _date = [your the date of the day Measure]
RETURN
CALCULATE([Your value], DATESBETWEEN('Date Table'[Date], _x_days_before_date, _date]
You would get the y values only for those dates, everything outside will be blank and not presented on the chart and axis will start from your desired start to end.
@maxduff59 if you will create a measure like:
MEASURE =
VAR _x_days_before_date = [Your Date x days before Measure]
VAR _date = [your the date of the day Measure]
RETURN
CALCULATE([Your value], DATESBETWEEN('Date Table'[Date], _x_days_before_date, _date]
You would get the y values only for those dates, everything outside will be blank and not presented on the chart and axis will start from your desired start to end.
I will try that, thank you. I just have a little question, why do I need to redefine my date measures through variables ?
Moreover, what is the first term of the CALCULATE function [YOUR VALUE] ?
@maxduff59 variables are always good thing to use for code readability and better performance. In some cases you must use them cause sometimes if you put your measures inside another calculate filter argument you might not get what you want.
Of course you can't use, btw, variables as something to put in the 1st argument of calculate cause they are already been executed.
Actually, yesterday came out a cool video I recommend to watch:
https://www.youtube.com/watch?v=NbbE39gwVVo
Please don't forget to accept the relevant messages as a solution for community visibility. P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂 https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Thanks for the explications, I just don't understand which term do I need to put first in the CALCULATE function...
you put there an aggregation expression ususally, and you can also call a measure instead. The think I meant that in this case you can't use a var before it and call it inside. But I think the video explains it better.
Let me know that is what you meant.
User | Count |
---|---|
141 | |
70 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |