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

Timeline with two bar charts

Hi,

 

I have a timeline visual and two stacked bar charts. The bar charts represents actual and forecast man hours. I am trying to use the timeline to show the actual vs. forecast for the selected time period. My problem is linking the second bar chart to the timeline. The first bar chart (forecast works fine). I have attached a screen shot, appreciate any help or suggestions.

 

TIAtimeline visual.PNG

3 REPLIES 3
Community Support
Community Support

Re: Timeline with two bar charts

HI @rodolsen,

 

If you mean interaction of these visuals, you can simply turn on 'edit interaction' to edit interaction effect of each visuals.(at format tab)

1.PNG

 

Regard,

Xiaoxin Sheng

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

Re: Timeline with two bar charts

Hi v-shex-msft,

 

Sorry I am being a little vague. What I am trying to do is show the forecast days in comparison to the actual days. I am struggling to work out how to add a timeline (slicer) that will adjust both bar graphs (the data is stored in two different tables).

 

I have a week ending field in each table that I want to slice on. When I change the slicer value I would like to see the forecast days and actual days re-adjust based on the date. That way I can see what was forecast vs what actually happended at a point in time.

Community Support
Community Support

Re: Timeline with two bar charts

HI @rodolsen,

 

>>I am struggling to work out how to add a timeline (slicer) that will adjust both bar graphs (the data is stored in two different tables).

Nope, it is impossible. Power bi not support use one filter/slicer to return different result.

 

Regards,

XIaoxin Sheng

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.