How to hide items in visual in Power BI

[Analitika]

Hello,

I wonder if possible some items in visual legend as some data is empty, I have a measure which calculates data by 2024 but 2024 is not existing and that items exists in visual. So is possible to hide not interesting items in visual? 

Visual looks like this:

And visual pane:

Any workarounds?

[Fayaz_1ly]

Try using selection panel from View ribbon in Power BI

[Analitika]

It is not clear actually for me.

[bhelou]

Solution for better dataset and to be more dynamic : 

1 - go to your dates table 
2 - Create a new column with this measure : 

Future_Day : = IF(

'*Dates'[Date]

>TODAY(),TRUE(),FALSE()) 
3 - drop  the Future_Day measure in filters - Filters on all pages  - then select False : here it will take all the dates of the table within the values of today and backwards ) 

Kindly  accept as a soulution and a kudo is greatfful . 

[Analitika]

Just false I see in filter.

[bhelou]

Kindly share some sample of the PBIX file to see what is happeninig with you 

[Analitika]

I have sensitive data

[bhelou]

Dear , 

Check your dates table , do you have the year 2024 inside it ? 

[Analitika]

No it doesn't that table in which I added column has years until 2023. Measure EUR / h 2024 checks if table contains 2024 year.

[bhelou]

Ok got you , please if you can share the measure to see how we can remove the blanks from it . 

[Analitika]

Pardavimai santykis_h_k1_kiek_2024 = 
var metu_uzdarymo_pozymis=[ABC_Metu_uzdarymo_ZU0_KOD]
var valandos= CALCULATE([kiekis_talble2],FILTER('view_ziniarast_cp','view_ziniarast_cp'[year]=2024))
/*var savikaina= sumx(FILTER('DBA view_DidknObj', RELATED('Sas kod unik BRIDGE'[POZYMIAI Veiklu (Excel AUTO)])="Savikaina"&&Find(metu_uzdarymo_pozymis,'DBA view_DidknObj'[ZU0_KOD],,0)=0), 'DBA view_DidknObj'[SUM_DEB]-'DBA view_DidknObj'[SUM_CRE])*/
return


if([kiekis_talble2]=BLANK(),"",DIVIDE([BP Pardavimai DK+-50],valandos))

year column is from table

[bhelou]

Hello , Try to modify the return statement after devide , add this  and let me know if it works : 

IF(ISBLANK(DIVIDE([BP Pardavimai DK+-50],valandos)), BLANK(), DIVIDE([BP Pardavimai DK+-50],valandos))

[bhelou]

Hello , 

1- In the filter of the visual , you can filter out the year or the blanks 
2- make a measure with a variable to filter out the blanks , ( share the measures here to help you with it ) 
3- Make your date table more dynamic ( add a new column and select the date you are standing on , if it is more then make true or false ( example : today is 29 March , : Measure in the column of the dates table : Future_Day : = IF(

'*Dates'[Date]

>TODAY(),TRUE(),FALSE()) 

in this measure you will have true or false , then in the report in the filters pane put it in all pages then select the false ( here it will be dynamic date on a daily base refresh ) 

Please accept as a soulution and a kudo is greatfful . 

Regards  , 





Regards ,