Can we display bullets based on values

[Prashant S A]

Hi,

 

I am looking to create a visualization like attached one

Graphical chart is not usable, the requirements is similar to table viz and instead of numbers bullet color would display column wise.

 

Any inputs appreciated.

[Niko Maresco]

hi Prashant,

assuming that you have 1) a column with a trinary value of some kind (e.g., 1, 2, or 3) and 2) images for these circles/bullets hosted in a publicly accessible location (e.g., http://example.com/red_dot.png, etc.), you can use a regular Table visualization:

1. convert your trinary value to a URL for the respective image with a Calculated Column using an expression like the below example. here i assume that your trinary value is in a column called [value], and i will refer to the new Calculated Column as [value_url].

   case [value]
     when 1 then "http://example.com/red_dot.png"
     when 2 then "http://example.com/green_dot.png"
     when 3 then "http://example.com/yellow_dot.png"
     else null
   end

2. create a new Table visualization and ensure that [value_url] is displayed
3. enter the Properties dialog for the Table visualization and navigate to the Columns page
4. select your [value_url] column and change the Renderer to "Image from URL" (see image)
5. repeat these steps for any additional columns

[Vincent Thuilot]

Hello,

Assuming you don't have too many bullets another option could be to create your table in excel, do your initial formatting there.

Then, copy paste the formatted table in a text area and insert Icon in the needed cells.

 

It's not easily scalable but it will do the job if you have a fixed number of KPIs

Vincent

[Prashant S A]

Thanks for your inputs, Nico and Vincent.

To my use case, I choose to go with Nico