Forum Discussion

ZiyadSyauqi's avatar
ZiyadSyauqi
Frequent Visitor
1 year ago

Border Marker in Line and Stacked Column Chart Seems Error

Hello Fellas,

I have data something like this:

MonthMonthIDValueLine
January110060
Februari2200074
March33000057
April420021
May5300078
June64000090
July750047
August8600033
September97000068
October1080049
November11900095
December1210000039

 

and i want to make Line and Stacked Column Chart like this:

 

i want to give blue border to the marker using this:

 

but when i clicked Border radio button to on, it automatically swicth to off...

is it a bug? how can i solved this? i already updated my PowerBI to the latest version January 2025. Please help.

 

thanks!

Need Help
Tutorial Requests

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi ZiyadSyauqi 

     

    I agree with Ritaf1983 . This is probably not a bug. Marker border is a new feature introuduced in Power BI October 2024 update. In the update blog, it mentions that the new format settings have been added to markers for line charts, scatter charts, and anomalies. The combo charts are not mentioned, so maybe they are not supported currently. 

     

    Best Regards,
    Jing
    Community Support Team

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    1 year ago

    Hi ZiyadSyauqi 
    This is not a bug.  Power BI doesn’t offer the functionality to add borders to markers in core combo charts. This feature is available in single line charts or in line charts with dual Y-axes.

    You can report it as an idea here :

    https://ideas.fabric.microsoft.com/ideas/search-ideas/?q=marker%20border&page=1

    P.S

    However, it’s important to note that from the perspective of effective data visualization and UX principles, using dual Y-axes violates a fundamental rule—avoiding misleading representations, as emphasized by Don Norman. In combo charts, where a line is overlaid on columns, we instinctively compare the heights of the elements, assuming they belong to the same scale or category (a perception influenced by Gestalt principles). But this is misleading not only because of scale differences but also because these are two fundamentally different metrics that shouldn’t be directly compared. This creates a false sense of correlation where none may exist.

    The real goal of such visualizations should be to analyze the behavior of the two metrics and identify where they align or diverge. A more effective approach is to use two separate charts stacked vertically.

    To further enhance clarity, you can apply conditional formatting to highlight points of similarity or divergence in the metrics, depending on the message you want to convey.

    For example :

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