Forum Discussion
dynamic graphic with calculated columns
- 5 years ago
Hello, @Ley022
It's a pleasure to answer for you.
According to its description, I think you can create a table (enter data) with a single column that includes all calculated column name elements, and then create a measure used in the 'values' of the stacked column chart.
Measure = SWITCH ( TRUE (), SELECTEDVALUE ( 'Table (2)'[IN] ) = "IN1", MAX ( 'Table'[IN1] ), SELECTEDVALUE ( 'Table (2)'[IN] ) = "IN2", MAX ( 'Table'[IN2] ), SELECTEDVALUE ( 'Table (2)'[IN] ) = "IN3", MAX ( 'Table'[IN3] ), SELECTEDVALUE ( 'Table (2)'[IN] ) = "IN4", MAX ( 'Table'[IN4] ), SELECTEDVALUE ( 'Table (2)'[IN] ) = "IN5", MAX ( 'Table'[IN5] ) ) // max(your calculate column)Like this:
Here is my sample .pbix file. I hope it helps.
If you do not solve your problem, please feel free to ask me.
Best regards
Janey Guo
If this post helps,then consider Accepting it as the solution to help other members find it faster.
Hello, @Ley022
It's a pleasure to answer for you.
According to its description, I think you can create a table (enter data) with a single column that includes all calculated column name elements, and then create a measure used in the 'values' of the stacked column chart.
Measure =
SWITCH (
TRUE (),
SELECTEDVALUE ( 'Table (2)'[IN] ) = "IN1", MAX ( 'Table'[IN1] ),
SELECTEDVALUE ( 'Table (2)'[IN] ) = "IN2", MAX ( 'Table'[IN2] ),
SELECTEDVALUE ( 'Table (2)'[IN] ) = "IN3", MAX ( 'Table'[IN3] ),
SELECTEDVALUE ( 'Table (2)'[IN] ) = "IN4", MAX ( 'Table'[IN4] ),
SELECTEDVALUE ( 'Table (2)'[IN] ) = "IN5", MAX ( 'Table'[IN5] )
)
// max(your calculate column)
Like this:
Here is my sample .pbix file. I hope it helps.
If you do not solve your problem, please feel free to ask me.
Best regards
Janey Guo
If this post helps,then consider Accepting it as the solution to help other members find it faster.