Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
1 year ago
Solved

dotted line

can it be possible to show dotted line like below highlighted?

 

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi powerbiexpert22 ,

    I create a table as you mentioned.

    Then I think you can put it into the Stacked bar chart.

    Next you can choose Divider in Title.

    You can choose Line style and it will get what you want.

     

     

    Best Regards

    Yilong Zhou

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi powerbiexpert22 ,

    I create a table as you mentioned.

    Then I think you can put it into the Stacked bar chart.

    Next you can choose Divider in Title.

    You can choose Line style and it will get what you want.

     

     

    Best Regards

    Yilong Zhou

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

  • saud968's avatar
    saud968
    Memorable Member

    Here are a couple of methods you can consider:

    1. Using a Shape Visual:

    Create a Shape: In Power BI, insert a shape visual and choose a rectangular shape.
    Position the Shape: Place the shape where you want the dotted line to appear, ensuring it aligns with the section you want to highlight.
    Format the Shape:
    Set the fill color to "No Fill."
    Adjust the border color to your desired color.
    In the "Line" section of the Format pane, select "Dashed" or "Dotted" for the line style.
    Experiment with the line width and dash/dot pattern to achieve the desired appearance.
    2. Using a Line Chart with No Data:

    Create a Line Chart: Insert a line chart onto your report.
    Configure the Chart:
    Set the chart type to "Line."
    Ensure there's no data assigned to the chart.
    Format the line as described in the previous method (dashed/dotted, color, width, etc.).
    Position the line chart where you want the dotted line to appear.

    Best Regards
    Saud Ansari
    If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!


  • Hi I found your bar chart really nice. Did you make that from the default visual or did you get that from the "more visuals" Thank you!