Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Trouble with piled columns graph (2 values)

Hi!   I've been having some trouble making a 2-value graph, data type: date/time and recount.   Context: it's a monthly report of a Help Desk that opens and closes tickets on a platform. The grap...
Need Help
Tips and Tricks
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  Anonymous 

For your case, there are two date columns (Worksheet[Open Date]/Worksheet[Close Date]), so you'd better create two relationship to calendar, then write two measures with userelationship function to choose which relations works for measure.

here is blog, please refer to:

USERELATIONSHIP Function (DAX)

USERELATIONSHIP in Calculated Columns

 

If you still have the problem, please share the sample pbix file and your expected output.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Regards,

Lin