Forum Discussion
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...
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 -
Hi ldenney ,
We can also use the following measures as line values to meet your requirement:
State Acute Indicator 1 =
CALCULATE (
SUM ( 'State Acute'[State Acute Indicator 1] ),
FILTER (
ALLSELECTED ( 'State Acute' ),
[fy_end_dt] IN FILTERS ( 'Hospital'[Fiscal Year End] )
)
)
State CAH Indicator 1 =
CALCULATE (
SUM ( 'State Acute'[State CAH Indicator 1] ),
FILTER (
ALLSELECTED ( 'State CAH' ),
[fy_end_dt] IN FILTERS ( 'Hospital'[Fiscal Year End] )
)
)
US Actue Indicator 1 =
CALCULATE (
SUM ( 'US Actue'[US Actue Indicator 1] ),
FILTER (
ALLSELECTED ( 'US Actue' ),
[fy_end_dt] IN FILTERS ( 'Hospital'[Fiscal Year End] )
)
)
US CAH Indicator 1 =
CALCULATE (
SUM ( 'State Acute'[US CAH Indicator 1] ),
FILTER (
ALLSELECTED ( 'State US' ),
[fy_end_dt] IN FILTERS ( 'Hospital'[Fiscal Year End] )
)
)
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.