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
joshua1990
Post Prodigy
Post Prodigy

Charticulator - Alternative Text Color

Hi experts!

I have a simple bubble chart in charticulator with a text field that shows me the exact value. The bubbles are black and the text is white.

Since there are also values of '0' I see nothing in the visual in the end.

Is it possible to get a black text if Value is '0'?

Is it somehow possible to bring a dax measure with color information into that conext?

1 ACCEPTED SOLUTION
dm-p
Super User
Super User

Hi @joshua1990,

You can't assign colour values directly (e.g., by hex code), as Charticulator binds numeric values as a gradual colour scale. If you want to do this without modelling, you can do user two text marks (one for zero values and one for everything else), e.g.:

dmp_1-1654636529254.png

How you should be able to reproduce:

 

  1. For your existing text mark (which we'll use for the non-zero values in this example), drag your measure value to the Visibility attribute, e.g.:

    dmp_2-1654636650864.png

  2. Click on the created scale (i) to bring up the scale editor. Ensure that your measure is selected (ii), and then set the Boolean condition to Greater than 0 (iii), e.g.:

    dmp_3-1654636825160.png

     

  3. Add another text mark, that is the same as your primary label.

  4. Give this a different name.

  5. Set its position to the same as the primary text mark.

  6. Set its Color attribute to black.

  7. This all may look messy for the moment, but we'll sort that next, e.g.:

    dmp_4-1654636959853.png

  8. Hold the Shift key and drag your measure to this mark's Visibility attribute. Holding the Shift key is very important, as this will tell Charticulator to create a new scale for the attribute, and not re-use the existing one. You should see something like the following if this has worked:

    dmp_5-1654637116371.png

    If it hasn't worked, you will see something like this (this is incorrect, as Charticulator will use the same conditions to show/hide the marks):

    dmp_6-1654637160883.png

    If this has happened, remove the Visibility attribute data binding from your 'zero' mark and repeat the step.


  9. Click this new scale to open the scale editor, and set the Boolean properties to Equal to 0, e.g.:

    dmp_7-1654637316897.png

  10. This will now hide the values greater than zero and will (hopefully) look how you expect it to, e.g.:

    dmp_8-1654637368025.png

     

All being well, this is all you should need to do. Good luck!

 

Daniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




View solution in original post

1 REPLY 1
dm-p
Super User
Super User

Hi @joshua1990,

You can't assign colour values directly (e.g., by hex code), as Charticulator binds numeric values as a gradual colour scale. If you want to do this without modelling, you can do user two text marks (one for zero values and one for everything else), e.g.:

dmp_1-1654636529254.png

How you should be able to reproduce:

 

  1. For your existing text mark (which we'll use for the non-zero values in this example), drag your measure value to the Visibility attribute, e.g.:

    dmp_2-1654636650864.png

  2. Click on the created scale (i) to bring up the scale editor. Ensure that your measure is selected (ii), and then set the Boolean condition to Greater than 0 (iii), e.g.:

    dmp_3-1654636825160.png

     

  3. Add another text mark, that is the same as your primary label.

  4. Give this a different name.

  5. Set its position to the same as the primary text mark.

  6. Set its Color attribute to black.

  7. This all may look messy for the moment, but we'll sort that next, e.g.:

    dmp_4-1654636959853.png

  8. Hold the Shift key and drag your measure to this mark's Visibility attribute. Holding the Shift key is very important, as this will tell Charticulator to create a new scale for the attribute, and not re-use the existing one. You should see something like the following if this has worked:

    dmp_5-1654637116371.png

    If it hasn't worked, you will see something like this (this is incorrect, as Charticulator will use the same conditions to show/hide the marks):

    dmp_6-1654637160883.png

    If this has happened, remove the Visibility attribute data binding from your 'zero' mark and repeat the step.


  9. Click this new scale to open the scale editor, and set the Boolean properties to Equal to 0, e.g.:

    dmp_7-1654637316897.png

  10. This will now hide the values greater than zero and will (hopefully) look how you expect it to, e.g.:

    dmp_8-1654637368025.png

     

All being well, this is all you should need to do. Good luck!

 

Daniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




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.