Forum Discussion

kpavan999's avatar
kpavan999
Frequent Visitor
4 years ago
Solved

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...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    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

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

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