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 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.

 

TIA

Need Help

3 Replies

  • 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