Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi everyone!
My line chart has two lines: one for current year sales (CY) and the other for prior year sales (PY). For the most recent year, CY records stop in May. I would like for the chart to not display any months beyond May for the PY. I have a slicer for the years.
Any suggestions? 🙂
Solved! Go to Solution.
Hi,
Try this measure
PY net sales new = if([Net sales]=blank(),blank(),[net sales])
If this does not work, then share the download link of the PBI file.
Hi everyone! Thank you for all the suggestions, I went ahead with @Ashish_Mathur's solution because it was the most straightforward approach.
Hi,
Try this measure
PY net sales new = if([Net sales]=blank(),blank(),[net sales])
If this does not work, then share the download link of the PBI file.
create a calcuated column inside dimdate table that will return 1 or 0 base on this condition :
new column =
var max_date = max(table_name[date]) -- table_name = the fact table on which your calculations are based, such -- as net sales, gross sales ,...
RETURN
switch(
true(),
dimdate[date] <=max_date , 1, 0 )
after you finish this column,
put it in the filter pane on page level , and choose advanced filtering :
is = 1
this should fix your problem .
let me know if this would help .
best regards
Hi @rqh
You could use a measure like this to filter your visual.
_Include =
VAR _EndOfSales =
MAXX(
ALL( 'Sales'[Date] ),
'Sales'[Date]
)
VAR _EndOfMonth = EOMONTH( _EndOfSales, 0 )
VAR _Logic =
IF(
SELECTEDVALUE( 'Date'[Year] ) = BLANK(),
1,
IF(
MAX( 'Date'[Date] ) > _EndOfMonth,
0,
1
)
)
RETURN
_Logic
Let me know if you have any questions.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |