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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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)

 

Regard,

Xiaoxin Sheng

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