Forum Discussion

ldenney's avatar
ldenney
Regular Visitor
6 years ago
Solved

Line & Clustered Column Chart

Hello Community - I am working on a line and clustered column chart. The x axis is fiscal year end and the Y axis are an indicator. The columns are an indicator for a hospital and I need to add 4 be...
Need Help
  • ldenney's avatar
    ldenney
    6 years ago

    Hi v-lid-msft 

     

    I have tried the "cross filter direction" as both and it doesn't work. I will try the fiscal year column in another calendar table and let you know how it goes.

     

    Regards -

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi ldenney ,

 

We can try to set the "Cross Filter direction" as both for each benchmark table and hosptial table, or we can use a fiscal year column in another calendar table as the x-axis field.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ldenney's avatar
ldenney
Regular Visitor
6 years ago

Hi v-lid-msft 

 

I have tried the "cross filter direction" as both and it doesn't work. I will try the fiscal year column in another calendar table and let you know how it goes.

 

Regards -

  • ldenney's avatar
    ldenney
    Regular Visitor
    6 years ago

    Hi v-lid-msft - I was able to get the visualization to work last night by using the fiscal year column in another table and linking everything to that table. Thanks so much for your help. I will keep your other suggestion in mind.

     

    Thanks a million!