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.
Could you please share sample data of your tables and elaborate what is the relationship between these tables with screenshots?