Skip to main content
cancel
Showing results for 
Search instead 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.

Reply
PowerConsumer21
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 A2011Game A
Company A2012Game B
Company A2013Game C
Company A2015Game D
Company B2013Game E
Company C2014Game F
Company C2015Game G
1 ACCEPTED SOLUTION
vanessafvg
Super User
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

vanessafvg_0-1687467995563.png

vanessafvg_1-1687468067772.png

 

 





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!




View solution in original post

3 REPLIES 3
vanessafvg
Super User
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

vanessafvg_0-1687467995563.png

vanessafvg_1-1687468067772.png

 

 





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!




yep you could just drag the measure like i have here

 

vanessafvg_0-1687541684760.png

 





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!




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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

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

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors