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

Bar Chart - Custom x-axis grouping

Hello,

 

I'm trying to figure out how to design a bar chart that contains data at different levels. I need to create a chart that shows Prior Year End actual, Current Quarter Actual, Current Quarter Plan, Year End Plan in this order. The only way I can think to accomplish this would be to create a custom column based on date selected in the slicer. Is it possible do this this? I'm still struggling to learn DAX, but I know it can do amazing things.

 

This is an example of what the users want to see - Example Look  - The main task I'm struggling is how to turn quarter end data into 4 different bars (Prior year end actual, Current Quarter Actual, Current Quarter Plan, Year End Plan)

This is the example data I have to go off - Example Data 

1 REPLY 1
Community Support
Community Support

Re: Bar Chart - Custom x-axis grouping

HI @jhendrsn ,

Nope, power bi does not support to create dynamic calculate column/table based on filter/slicer.

For your requirement, I'd like to suggest you take a look t the following blog about dynamic attribute filter:

Dynamic Attributes In A Power BI Report 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors