Forum Discussion

Ma_Vo's avatar
Ma_Vo
New Member
9 years ago

Adjusting slicers

Hi,

 

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.

 

Example:

 

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

Matthias

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Ma_Vo,

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


    Regards,
    Lydia Zhang