Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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's avatar
    Anonymous
    6 years ago

    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.

2 Replies

  • CoreyP's avatar
    CoreyP
    Icon for Solution Sage rankSolution Sage

    Hey there,

     

    Can you share your data? Screenshot or sample text.

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.