Ocultar valores en grafico

[Damian_C]

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

[Anonymous · Accepted 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.