Forum Discussion
Help with line and stacked chart
In the below line and stacked column chart, can we show the values with "Y" as lines?
One option that i could think of is by creating 2 variables like below and have each of that in column values and line values, but not able to create measure like this. Any thoughts pls
1. score where flag=Y
2. score where flag=N
Hello, kpavan999
You can create meausures.
Like this:
Y = CALCULATE(MAX('Table'[score]),'Table'[Flag]="Y")N = CALCULATE(MAX('Table'[score]),'Table'[Flag]="N")Then put N in column values and Y in line values.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
2 Replies
- amitchandak
Super User
kpavan999 , You need to create a measure score with flag Y and Flag with N and then use them as measures in stacked line or clustered line visual and show the measure with flag Y on line
- v-janeyg-msft
Community Support
Hello, kpavan999
You can create meausures.
Like this:
Y = CALCULATE(MAX('Table'[score]),'Table'[Flag]="Y")N = CALCULATE(MAX('Table'[score]),'Table'[Flag]="N")Then put N in column values and Y in line values.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
