girish_singhal
5 years agoNew Member
Status:
Needs Votes
Line Chart Marker Color Conditional Formatting
It really helps if we can do conditional formatting of Marker color on Line Chart. That will help in distinguishing any data points that we want to highlight. Currently work around of applying conditional formatting on Bar Chart and then converting it back to Line Chart works but the color/size of the marker gets obscured by the color scheme of (bar -> marker) for the chart itself. I tried to resize the marker size to 6 to reduce the footprint of default color scheme of "bar -> marker" but that renders the marker size to be very small. If I increase the marker size then the default color scheme renders/overshadows the condition color of the data point that has a special color (derived out of conditional formatting applied to bar chart before it was converted to line chart. The same can be seen in the below screenshot.
8 Comments
- US314564New MemberThanks for finding the workaround, which is still usable as of 2.92.706.0. The ability to highlight individual points on the line chart based on the value of a specified field would provide valuable new capability, especially if able to customize the points beyond what is allowed by the bar chart to line chart workaround.
- holger_schimansNew Member
See similar request https://ideas.powerbi.com/ideas/idea/?ideaid=bf62a5fa-d376-ed11-a76e-281878bd0909
- vinicius_aranteNew Member
This would be great! An must be for almost all line charts who deals with "good / bad' values.
- fbcideas_migusrNew MemberStatus added:Needs Votes
- EAB1977Frequent VisitorHow many votes are needed for the Devs to take on a request like this? It seems like something that could easily be added.
- AbigailColeAdvocate IThis would be so useful!!
- Soporte_GFSNew MemberBe careful to show ONLY ONE series in this hack... otherwise you'll lost the customization icon even in bar charts... just remove all series but the one you wanna customize, apply the bars hack, convert to line chart again and then add all other series you need in your line chart
- RPProhaskaRegular VisitorTearing my hair out trying to conditionally format markers. All the on-line articles on work arounds for this are dated and none of them work in the current PBI release. Microsoft, please add conditional formatting for line chart marker colors.
Recent ideas
:: operator for typecast in T-SQL
Introduce support for the ::type cast operator in Fabric Data Warehouse as syntactic sugar for the existing CAST(... AS type) expression. The new operator would be functionally equivalent and compile...jovanpop-msft1 hour agoMicrosoft EmployeeNew5Views0likes0CommentsNative Multi-Visual Cascading Selection (Beyond Ctrl + Click)
The Problem: When working with multiple tables or matrices on a report page, users frequently need to chain selections together (e.g., clicking Matrix A filters Matrix B, and then clicking Matrix B ...7407545 hours agoNew MemberNew12Views0likes1CommentPipeline activity Refresh SQL Endpoint (preview) does not accept dynamic content
I am testing out the new Pipeline activity for Refresh SQL Endpoint, currently in preview. Sure, I get it that this is in preview, but it should at least have basic minimum functionality. It do...ToddChitt6 hours agoSuper UserNew569Views7likes5CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf6 hours agoFrequent VisitorNew30Views1like1CommentSupport Git-Integrated Files in Fabric Workspaces
Overview Allow users to store and manage arbitrary files such as .md, .sql, .py, and .yml directly in a Fabric workspace, with built-in Git integration. Value This would keep documentation, SQL sc...ryomaru08256 hours agoAdvocate INew9Views0likes0Comments