Forum Discussion
bdehning
Post Prodigy
2 years agoCombine two visuals on one Clustered Column Chart
Is it possible to get two visuals onto one Clustered Column Chart? So if I show Years on the X Axis I will see two columns for each year, with each column having its own set of Filters.
Anonymous
2 years agoNot applicable
Hi bdehning ,
Please tell me is this the result you expect to get?
Here is my sample data:
I created two measures and put them into the Clustered Column Chart to exist as values:
SUM = CALCULATE(
SUM('Table'[Value]),
FILTER(
'Table',
'Table'[ID] = SELECTEDVALUE('Table (2)'[ID_SUM])
)
)AVERAGE = CALCULATE(
AVERAGE('Table'[Value]),
FILTER(
'Table',
'Table'[ID] = SELECTEDVALUE('Table (3)'[ID_AVERAGE])
)
)
Create a slicer based on table (2) and table (3) respectively. The results are as follows:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.