visualize power bi with respect to dates ( weekly, monthly, yearly)

[vat2do]

Hi 

Hope you have good day,

I have 5 different visuals on my power Bi Dashboard all are inter related through a source table haing 5 unique categories, its working fine i can see the source category wise out put which is as per my requirement but...

Now i want to see the output of a specific source category with respect to a specific date duration like weekly based, monthly or yearly

Can anyone explains how is that possible as i want to use a slicer visual on top of my source table to see different outputs based on date wise specific category

Note:

All my tables are having created date, resolved date, breach date columns but i am still not using them 

Appreciated if any solution 

Thanks in advance

[Anonymous · Accepted solution]

Hi @vat2do ,

Please review the following threads which has the similar requirement as yours, hope they can help you get your expected result.

Change time period (week, Month, Quarter...) on slicer selection

Power BI How To: Adding a Monthly/Annual switch to a Dashboard

Measure to show the data as "daily","weekly","monthly" in power bi?

There are 2 common ways to make this work :

Way-1 : Utilizing Power Query

1. Create a "Date Table" using the date column in power query
2. Add 3 calculated columns that extracts month, week and day info from the "Date" column in the newly created "Date Table".
3. Now, unpivot the "month", "day" and "year" columns and load the file.
4. Create a one to many relationship with "Date" columns as common in both tables and there you go.

Way-2 (Using Drill-through buttons).

Use the recent feature update of Power BI, i.e., drilling the data using buttons. So, you just need to create a date hierarchy and then drill through using buttons for "month", "week"and "day".

I hope this will help you.

If you still got the doubt then please send me the dataset and I will give you an detailed explanation on this.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[ToddChitt]

Can you give us an example of what you have now, and what you want to achieve? Sample data is also good to share, if possible.