Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Fiscal Year Slicer

How to create a fiscal year slicer for different companies, with each company start with different fiscal year.

e.g:- There are four companies: A, B, C, and D. If I select company A, then in the slicer, the fiscal year for company A will be displayed.
(Slicer will show the fiscal year specific to the selected company.) Likewise for other companies.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous 

    You can create a single table and it just contains values{"A","B","C","D}, then put the value to the slicer, then create a new column in the fiscal year table, if year blongs to "A", then give it the value "A" , or other values(B/C/D), then create a relationship 1:N between the new column of fiscal year table and the column of new table. Then when you choose the value in slicer, the  fiscal year table will display the related content. 

    If the information above cannot meet your requirements, can you provide some sample data or picture, so that can provide more useful suggestion for you.

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.