cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

## 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 make them stand out for that year if it was newly established. Out of all companies that published a game on 2011, Company A would stand out (Like a different color at the end) as it was the first initial launch alongside any other companies that published a game in that year. Any subsequent years, Company A would not stand out as it has existed since 2011. Thank you in advance!

 Year (Date column) Company A 2011 Game A Company A 2012 Game B Company A 2013 Game C Company A 2015 Game D Company B 2013 Game E Company C 2014 Game F Company C 2015 Game G
1 ACCEPTED SOLUTION
Super User

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

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

3 REPLIES 3
Super User

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

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Super User

yep you could just drag the measure like i have here

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Frequent Visitor

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.

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors