Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin 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!
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
15 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
22 | |
11 | |
10 | |
10 | |
8 |