Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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.
Solved! Go to Solution.
@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)
________________________
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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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
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).
@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)
________________________
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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
wow what a brilliant solution. amazing!
@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.
@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.
@Anonymous , refer if this can help
https://blog.enterprisedna.co/add-custom-icons-to-power-bi-reports/
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
Regards,
Harsh Nathani
Thanks! This was the best solution I found! and it worked 😀
User | Count |
---|---|
93 | |
92 | |
85 | |
83 | |
49 |
User | Count |
---|---|
150 | |
142 | |
112 | |
73 | |
55 |