Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Triangle generator and ruler visuals

Hi everyone! I'm looking for this two visuals in PBI, or maybe similar to those:
First one (Triangle): 

I have 3 categories and 3 values per each. There is "Triangle generator" in Excel, but I need in PBI. So it has big triangle (orange), values for it 9, 9, 9. And smaller(green) triangle created by values per category( 4, 6, 3). In power BI it has "Radar" visual, it looks similar but works different.
Second visual I need is simple ruler:

It is like simple card, that show the value for one parameter. But in ruler way, with max value 9.|
Thanks in advance!

Need Help

3 Replies

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    I believe this could be make with the Deneb visual. Here is the basic approach:

    • Layer a triangle symbol with a very big size and color it orange (will need to tweak size once chart is created)
    • Create a x-y chart for your 3 circles and create measures that use basic trigonometry to calculate x and y values for each (x=0, y=4 for the first one, ~2.1, ~-2.1 for the 3, etc.)
    • Layer lines connecting each of the 3 circles, using x, x2, y, y2 values
    • Not sure how to color it green yet.


    Alternatively, it could likely be done with the Deneb visual using Vega (instead of Vega Lite), using the Path mark. With that, you can define a custom svg path, and then dynamically scale it with the size property. 

     

    This is an interesting one. I don't have time to try either approach out until later this week, but sharing the ideas in case someone else does.

     

    Pat