How to do a stacked bar chart with three different date columns

[Anonymous]

Hello everyone

The thing is, i got four columns each one with dates, and i want to do a stacked bar chart with these dates, the stacked bar chart is divided by months of the 2019, the values consist in counting the cells with each month, in the date columns, if the contract got the specific step, it got a data value, but if it didn't is blank, the problem is, i can put count the cells values filtering by months but, in the axis i don't know what date value to put, because, i got a date sheet but it can only get one relationship active at once, if i could get a multiple relationship or generate a generic date column so it can make the chart with the four areas o every column with the dates, it will be great, actually it only get the values of the active relationship, thanks in advance!

[Anonymous · Accepted solution]

Hi @Anonymous ,

Not sure if it would be helpful, but you can create an inactive relationship and use USERELATIONSHIP() function in measures to invoke the inactive relationship. For more details please check the document below.

https://docs.microsoft.com/en-us/dax/userelationship-function-dax.

It would be better if you could share some sample data and expected result to us if you don't have any Confidential Information. In that case we might help you more effectively.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CoreyP]

Hey there,

Can you share your data? Screenshot or sample text.