Help with Clustered Column Chart

AndrewDang

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

AndrewDang

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