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.
Dear all,
I have a line chart where i am showing the cummulative values for each month for actual period vs same period last year.
For the current month shown, November in this example (as per this month), I would only show the days of the month as per the day of the report (as per today for example), for the actual period line.
Do you know if this is possible? and if being possible, how can it be done?
This is what i would like
Thanks in advance,
@Anonymous,
As mentioned above, you may take advantage of Show items with no data and Visual level filters.
@v-chuncz-msft
I did try your solution but does not affect the view and does not get the wished result.
Depends on that calculation. Is that a measure? If so, then you should be able to use an IF statement to either return a value or BLANK().
@Greg_Deckler
Formulaes used are as follow:
Calculate cumulative:
Cumulative GPSales GC = CALCULATE([GPSalesGC_CY];FILTER(ALLSELECTED('Date'[Date].[Day]);'Date'[Date].[Day]<=MAX('Date'[Date].[Day])))
Where or how should i apply the IF statement?
Thanks and kind regards,
Cumulative GPSales GC = IF(LASTDATE('Date'[Date].[Day]) >= TODAY(), CALCULATE([GPSalesGC_CY];FILTER(ALLSELECTED('Date'[Date]. [Day]);'Date'[Date].[Day]<=MAX('Date'[Date].[Day]))), BLANK() )
Or something like that...
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |