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