Forum Discussion

ECE's avatar
ECE
Advocate II
6 years ago

Userelationship and interaction between visuals

Hi,   I have two graphs which shows the Sales Order Values (SO V), gruped by different dates (Created Date and Requested Date, both linked to my DataTable). I use the "UseRelationShip" function to ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

ECE 

In case you do not want to filter these two charts by common date. You can use dates from fact and create these charts. That might fulfill this need.

Else you may have to go for a two date dimension. This is my initial thought.

ECE's avatar
ECE
Advocate II
6 years ago

Hi amitchandak 

Thanks for your replay.
Your first solution is what I have done so far.. However, its not really ideal...

I would prefer not having to create extra colums in fact table, nor a second date table..

 

Br. Espen

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    HI ECE ,

     

    Create a duplicate of the calendar table and make an active relationship between this table and the requested date now use this table as the x-axis on the graphs were you want to have the requested calculations.

     

    No need to use the Requested Measure on your data except when you want to compare requested and created on the shame chart.

     

    Check PBIX file attach, chart 1 and 2 workihng as the 2 bottom ones.

    • ECE's avatar
      ECE
      Advocate II
      6 years ago

      Hi MFelix ,

       

      First of all, thank you very much your replay.

      I had hoped that it was possible to achieve the same result, without having to add extra tables / columns..

       

      Br. Espen