To explain my request is very simple (Dataset: Financial data set from Microsoft)
Display the sales by product based on the date slicers selected
Create a separate table Date series that contains the following data
If we select theDaythen it should display the day level data,Month- month level,Year- year level data. Could you please help me with this requirement, please.
Note: I tried the same requirement in this following method created 3 tables(month, year, day) based on the selection pane options I hide the tables and linked it by using bookmarks and it is working fine.