Forum Discussion

0Experience's avatar
0Experience
Helper III
10 months ago
Solved

How to Simplify a Line Graph with Multiple Types and Locations Using Solid/Dashed Lines?

Hello,   I have a line graph where the X-axis contains both year and type (in a hierarchical format), and the Y-axis represents values from a measure. The legend is used for the location.   For e...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • kushanNa's avatar
    kushanNa
    10 months ago

    Hi 0Experience 

     

    are you looking for an output similar to this ? 

     

     

    If this is what you are looking for, how about creating a summary table and manually changing the line color and style for different combinations? You can include the legend as an image, but the limitation is that the legend will not be interactive.

     

    I did color and line types change for one location as an example and attached the PBIX file for your reference.

rajendraongole1's avatar
rajendraongole1
Super User
10 months ago

Hi 0Experience  - Standard Power BI Line chart does not support dashed/solid differentiation.But custom visuals like Deneb (Vega-Lite) or Charticulator let you define line styles (strokeDash).

 

If you’re okay with custom visuals → use Deneb (best control, exact solid/dashed requirement).

If you prefer only native visuals → use Small multiples (keeps years on X-axis, legend by location, one panel per type).

 

Hope the above suggestion helps.

 

  • 0Experience's avatar
    0Experience
    Helper III
    10 months ago

    Hello rajendraongole1 

     

    Thanks for your response. However, unfortunately I can not use Small multiples because it is not gonna work for (trend analysis), and can not use external add-ons.

     

    Thanks again.