Forum Discussion

rodolsen's avatar
rodolsen
Frequent Visitor
8 years ago

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 ...
Need Help
rodolsen's avatar
rodolsen
Frequent Visitor
8 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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