Forum Discussion
Help with Clustered Column Chart
In the Shared Axis try using Month from DateKey? If that doesn't work try removing all other stuff except Month from DateKey and the 2 Measures as in my picture?
Thanks Sean
I am able to get the two different lines for 2015 and 2016 now. However, the set date and sold date numbers came out the same. I am expect a little differenciate between the two numbers... I will spend more time troubleshooting this tomorrow but i am just wondering if you have any quick tips.
Thanks Sean for your help. It has been fun and great working on this.
Andrew
Can you describe in more detail what you want the final result to look like?
Also read this http://community.powerbi.com/t5/Desktop/quot-Shared-Axis-quot-for-two-date-columns-on-Clustered-Line/m-p/25298#U25298
And then follow the link in Matt's answer - because you may need the set up desribed there...
If you do you'll need to create separate Measures - one for Set Date and one for Sold Date
Thanks Sean;
I will keep digging this. ultimately, I am trying to to do the same as what you had described on your blog. I need a line for # of Sold in a month (Sale in your example) and another line for # of Set for a month (Ship in your example).
I will keep digging this today to see if i can do this in Power BI.
Thanks for you help.
Happy Friday.
Andrew
Just add another inactive relationship as desribed in Matt's blog
http://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/
It should work!
Let me know if you cant make it work...