Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jarek
New Member

Line charts drill-down

Hi

 

I know that line charts in Power BI cannot be drilled-down but I'm looking for a nice workaround and would appreciate your inputs.

 

 

My data has four columns:

- Group (text)

- SubGroup (text)

- Month (date)

- Value (number)

 

I would like to create a line chart that shows Value by Month. Each line should represent particular Group/SubGroup. This is easy but the problem is when I try to build that logic:

- if a user did not filter any Group, show chart by Group

- if a user selected a Group, show chart by SubGroup

 

I tried building a measure that would tell me whether Groups or SubGroups should be shown and tried to use it as a visual-level filter but it does not seem to be a nice solution.

 

Regards,

Jarek

1 ACCEPTED SOLUTION
foodd
Super User
Super User

1 REPLY 1
foodd
Super User
Super User

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors