Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi I need help to change the color of my Line and Stacked Chart
Basically, i want the FY2024 to be another color than FY2023. I do not want to do it manually as I would then have to do it for the next 12 months manually for my users.
Please help! Thanks in advance!
Thanks,
Ricky
Solved! Go to Solution.
here is a workaround for you.
create measure
Proud to be a Super User!
here is a workaround for you.
create measure
Proud to be a Super User!
Hi @ryan_mayu Thanks! But what if my Year is Fiscal Year? Now it is showing for 2024 but not for Fiscal Year.... Please help me
You can do the similar way. Is the month and year from date table? Are they fiscal year and month?
Maybe just add the fiscal yar to the conditional format setting and set to 2024.
if still not work, pls provide some sample data.
Proud to be a Super User!
I have linked the actual date to the Dates table which is shown below.
When i try to add the Fiscal Year it always show as a SUM which is incorrect
then you can create a measure
Proud to be a Super User!
It Works!! Thanks so much !
you are welcome
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
9 |