Showing results for 
Search instead for 
Did you mean: 
Ma_Vo Occasional Visitor
Occasional Visitor

Adjusting slicers



I'm working with time series data (Excel) and i'm trying to visualize this data with Power BI.


Every single time series has a defined syntax, e.g. MNA.Q.N.I8.W2.S1.S1.B.B1GQ._Z._Z._Z.EUR.V.N . I'm using many time series which can differ in respect of periodicity (Q=quarterly, A=Annual,...), country, currency, adjustment,... So I have some standard code lists for mapping all the single features.


Now my problem: I don't have similiar data for all countries, e.g. only annual data for France or only unadjusted data for spain.

The standard code lists are containing more codes than I need.




Standard code list frequency:

A - annual

Q - quarterly

M - monthly

D - daily 


When I choose now a country with only annual data, the slicer for frequency will not adjust to this but is showing all possibilities which can be found in the standard code list.


What can I do to solve this problem? The single slicers shall adjust to what is still selected with respect of the actually available data and not showing all items of the standard code lists the whole time.


Thanks for your help.


Kind regards


Moderator v-yuezhe-msft

Re: Adjusting slicers


Could you please share sample data of your tables and elaborate what is the relationship between these tables with screenshots? 

Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.