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.
Buen dia, tengo este grafico acumulado, quiero matener el campo "programa" (o sea que se muestre hasta fin de mes) pero quiero que el campo "real" se muestre hasta el dia de la fecha.
En power BI:
Asi quiero que quede (lo arme en Excel):
Alguno sabria como hacer?? Saludos
Solved! Go to Solution.
Hi @Damian_C
In the first case, when the real value corresponding to your date is empty, you add [real] to the value, and the empty value is not displayed in the line chart.
In the second case , if you want to specify that real only display data up to a certain date (although later dates also have data), you can create a calendar date table and measure to control.
(1)Create a calendar date table .
Calendar date = CALENDAR(DATE(2021,01,01),DATE(2021,02,28))
(2)Create a measure to return the real that its date <= specified date .
Measure = CALCULATE(SELECTEDVALUE('Table'[Real]),FILTER('Table','Table'[Date]<SELECTEDVALUE('Calendar date'[Date])))
(3)Add a slicer with field ‘Calendar date’[Date] to filter data in data table . The final result is as shown :
I have attached my pbix file , you can refer to it .
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Damian_C
In the first case, when the real value corresponding to your date is empty, you add [real] to the value, and the empty value is not displayed in the line chart.
In the second case , if you want to specify that real only display data up to a certain date (although later dates also have data), you can create a calendar date table and measure to control.
(1)Create a calendar date table .
Calendar date = CALENDAR(DATE(2021,01,01),DATE(2021,02,28))
(2)Create a measure to return the real that its date <= specified date .
Measure = CALCULATE(SELECTEDVALUE('Table'[Real]),FILTER('Table','Table'[Date]<SELECTEDVALUE('Calendar date'[Date])))
(3)Add a slicer with field ‘Calendar date’[Date] to filter data in data table . The final result is as shown :
I have attached my pbix file , you can refer to it .
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
77 | |
60 | |
52 |
User | Count |
---|---|
165 | |
86 | |
68 | |
68 | |
58 |