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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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

amitchandak
Super User
Super User

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
refer : https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

 

develop: https://docs.microsoft.com/en-us/power-bi/developer/visuals/custom-visual-develop-tutorial

 

Map Json - Shape Map
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map
https://dataveld.com/2016/09/12/topojson-map-files-for-power-bi-shape-map/
https://medium.com/weareservian/power-bi-custom-maps-part-ii-shape-map-939873da3f66
https://radacad.com/shape-map-better-than-the-filled-map
https://doc.arcgis.com/en/maps-for-powerbi/get-started/prepare-your-data.htm

 


Appreciate your Kudos.

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
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

 

@Anonymous , refer if this can help

https://blog.enterprisedna.co/add-custom-icons-to-power-bi-reports/

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

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

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.