cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jschwab Frequent Visitor
Frequent Visitor

Line Chart Conditional Formatting and Plot Point Shapes

From what I can see, Line Charts do not have Conditional Formatting options.

However, if I create a Bar Chart with Conditional Formating on the Data Colors and then convert it to a Line Chart, I get a Line Chart with the same Conditional Formatting as the Bar Chart. So it appears Power BI can actually do Conditional Formatting on Line Charts.

Is there a way to access Conditional Formatting for Line Charts easily, or does it only work with the Bar Chart workaround ?

Secondary question, when creating a Line Chart with Conditional Formatting, it appears that each plot point is given a Circle shape automatically, I assume so it has an object to show the changes in colors rather than using the line itself.

Is there a way to change the shape that is displayed (ie Square, Triangle, Star, etc.) ?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Line Chart Conditional Formatting and Plot Point Shapes

Hi @jschwab ,

 

For your first question, there is no Conditional Formatting options for both the Bar chart and Line chart in the latest version of Power BI Desktop 2.69.5467.2151. If you need to set the data color for the Line chart, you can set in options below.

7.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

For your second question, you can change the plot point shapes following steps below.

1.Set the X axis type to "Categorical" instead of "Continuous", which will make the "Show marker" button available.

8.png

 

 

 

 

 

 

 

 

 

 

2.Turn on the "Show marker" button .Select the Marker shape you prefer from the drop down. For further customization => Turn On => Customize Series or other  Customize shapes, size, color and so on.

9.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Line Chart Conditional Formatting and Plot Point Shapes

Hi @jschwab ,

 

For your first question, there is no Conditional Formatting options for both the Bar chart and Line chart in the latest version of Power BI Desktop 2.69.5467.2151. If you need to set the data color for the Line chart, you can set in options below.

7.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

For your second question, you can change the plot point shapes following steps below.

1.Set the X axis type to "Categorical" instead of "Continuous", which will make the "Show marker" button available.

8.png

 

 

 

 

 

 

 

 

 

 

2.Turn on the "Show marker" button .Select the Marker shape you prefer from the drop down. For further customization => Turn On => Customize Series or other  Customize shapes, size, color and so on.

9.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

jschwab Frequent Visitor
Frequent Visitor

Re: Line Chart Conditional Formatting and Plot Point Shapes

Thank you @v-xicai for letting me know the Shape Markers appear only when it is a Categorical Axis. Although, I'd like to ask why they only exist for Categorical ? Here is the chart I currently have:

Line Chart.png

It's a Line Chart with a Continuous X-Axis. So the Marker Shapes appear to work for Continuous Axes, the options to change them just aren't in the UI. Also, I tried changing the Shapes as a Categorical Axis and then switching back to Continuous to see if it would stay just like the Conditional Formatting does, but no dice. It looks like when you use a Bar Chart to create Conditional Formatting and convert it to a Line Chart, you're stuck with Circles.

I'm guessing this is a bug, but I don't want it to go away since I can still use it with the workaround. Is there some place I can request Conditional Formatting and Marker Shapes be added to the UI for Continuous Line Charts ?

Community Support Team
Community Support Team

Re: Line Chart Conditional Formatting and Plot Point Shapes

Hi @jschwab ,

 

When changing the X axis to categorical , the data showing in graph will be focused on the data point.

 

Maybe you can post your new idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas , to improve the Power BI Desktop.

 

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team
Community Support Team

Re: Line Chart Conditional Formatting and Plot Point Shapes

Hi  @jschwab ,

 

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 6 members 3,034 guests
Please welcome our newest community members: