Forum Discussion

PowerConsumer21's avatar
PowerConsumer21
Frequent Visitor
3 years ago
Solved

Creating measure for stacked bar chart

Hello, I'm having trouble creating a measure, example table below. Third column is irrelevent but might help understanding so I included it. I'm creating a stacked bar chart to display companies and ...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • vanessafvg's avatar
    vanessafvg
    3 years ago

    you could do something like this

    create a flag for the first years

     

    IsNewYear =
     var com = SELECTEDVALUE('New Company'[Company])
     var yr= CALCULATE(MIN('New Company'[Date]), all('New Company'), 'New Company'[Company] = com)
     var dte = SELECTEDVALUE('New Company'[Date])
     return if(dte = yr, 1,0)
     
    and then do some conditional formatting on the chart when the value is =1

     

     

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
3 years ago

you could do something like this

create a flag for the first years

 

IsNewYear =
 var com = SELECTEDVALUE('New Company'[Company])
 var yr= CALCULATE(MIN('New Company'[Date]), all('New Company'), 'New Company'[Company] = com)
 var dte = SELECTEDVALUE('New Company'[Date])
 return if(dte = yr, 1,0)
 
and then do some conditional formatting on the chart when the value is =1

 

 

PowerConsumer21's avatar
PowerConsumer21
Frequent Visitor
3 years ago

Thank you for the reply! Would there be any way to display it on the same column? If multiple companies are in the same year, just the ones that published for the first time needs to be a different color.