Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Damian_C
New Member

Ocultar valores en grafico

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:

Damian_C_2-1645452720538.png

Asi quiero que quede (lo arme en Excel):

Damian_C_1-1645452701806.png

 

Alguno sabria como hacer?? Saludos

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

Ailsamsft_0-1645694656471.pngAilsamsft_1-1645694656473.png

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 :

Ailsamsft_2-1645694656477.pngAilsamsft_3-1645694656480.png

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.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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.

Ailsamsft_0-1645694656471.pngAilsamsft_1-1645694656473.png

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 :

Ailsamsft_2-1645694656477.pngAilsamsft_3-1645694656480.png

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.