cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lehikk Frequent Visitor
Frequent Visitor

Day/month/year filter with next and previous navigation

Hello,

First of all, I'm quite new to Power BI and sorry if I'm asking some dumb questions, as I'm not that familiar on what is doable on Power BI.

I'm looking for some ideas/insights on how to create a report that has a table visual showing numeric data in certain way: Because of the vast amount of data being produced, the data has been aggregated to rows containing hourly averages and daily averages. What I would need to have is a filtering option to show data from different time periods: Day, Month, Year. To keep the table readable, following requirements should be met:

1. Day view: Show 24 hour-type rows
2. Month view: Show 28-31 day-type rows, depending on month
3. Year view: Basically just month data averages

Also, it would be nice to have next/previous buttons to jump to next day/month easily, without the need of selecting dates from slicers, but is this possible to achieve in Power BI in some way? I'm a developer and writing code is not a problem (even though I'm not that familiar with Power Query or DAX, yet), but I'm trying to get some understanding on what's possible out-of-the-box and what's not. I've come across some solutions that are made of different visuals for different time periods, but that seems to be kind of brute force way of accomplishing the task and not very scalable.

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Day/month/year filter with next and previous navigation

HI @lehikk ,

According to your description, I'd like to recommend you to refer to following link about dynamic attribute slicer:

Dynamic Attributes In A Power BI Report

Please understand that this link is provided with no warranties or guarantees of content changes, and confers no rights.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Day/month/year filter with next and previous navigation

HI @lehikk ,

According to your description, I'd like to recommend you to refer to following link about dynamic attribute slicer:

Dynamic Attributes In A Power BI Report

Please understand that this link is provided with no warranties or guarantees of content changes, and confers no rights.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

Highlighted
lehikk Frequent Visitor
Frequent Visitor

Re: Day/month/year filter with next and previous navigation

Hi @v-shex-msft ,

Thanks for your reply. I actually found an "adequate" solution just by using few different slicers, but I'll definitely take a look into Dynamic Attributes as they would probably provide more flexible solution.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 46 members 908 guests
Please welcome our newest community members: