Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

How to add Dashed Line (Shape, NOT Chart) in Power BI?

Hi, I want to add Dashed Line in Power BI, just as a shape, not in graph. In Insert->Shape, I can find Line, but the Line is solid. I am unable to change it's properties to Dashed. Is there any way we can do that? Is anything available in the market? Some custom visual, maybe?

 

Any recommendation would be appreciated. Thanks.

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@Anonymous 

Add the following measure and drop it on a card Visual then format as you need, you can adjust the height in the measure:

Dash Line =  REPT("|"&UNICHAR(10),20)

Fowmy_0-1597645587312.png

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

11 REPLIES 11
Coriel-11
Resolver II
Resolver II

If you want to do diagonals, I recommend creating in DAX/importing/entering a mini table like this

Value1    Value 2

0             0

1             1

And then making a line chart from it. Remove all the axes, titles etc. and then you can style/size/place it as you like.

Matt

BritPearl
Regular Visitor

Add a rectangle, turn off "Fill" and "Border", and type in "- - -" as text & make it bold

Super easy to adjust the length of the dotted line by just adding more dashes and spaces, and optionally rotate the shape by 90 degrees for a verticle line!

Brilliant! Thanks. If you don't need to rotate it, you can also use a text box. This should be marked as the solution. Adding unnecessary measures is never a good solution.
The fact that Power BI developers waste their time on that 'on-object interaction' craziness rather than getting some basic functionality right is mind-blowing (e.g. making a line shape dashed, being able to specify column widths numerically, being able to LOCK the position of individual visuals, rather than all visuals at once, which is useless, etc, etc). 

Fowmy
Super User
Super User

@Anonymous 

Add the following measure and drop it on a card Visual then format as you need, you can adjust the height in the measure:

Dash Line =  REPT("|"&UNICHAR(10),20)

Fowmy_0-1597645587312.png

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

wow what a brilliant solution. amazing!

Anonymous
Not applicable

@Fowmy 

Thank you so much

Anonymous
Not applicable

@amitchandak , thank you for reply. Please see below image. This should clear things up. I added this Blue line through Insert->Shapes->Line. I want to make Blue Line Dashed.

 

ibraheem7_0-1597643234327.png

 

Hi @Anonymous ,

 

Add a Blank Button,

 

Go to Power Point and create a Dashed Line. Sve that Dashed line as image.

 

Bak to Power BI, go to fill section in the Blank Button and add the image (Dashed Line).

 

You can also try

 

https://community.powerbi.com/t5/Desktop/Dotted-line-around-the-data-section-in-the-Report-view/td-p/488192

 

Regards,

Harsh Nathani

Thanks! This was the best solution I found! and it worked 😀

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors