Forum Discussion

drcsjc's avatar
drcsjc
Frequent Visitor
3 years ago
Solved

Customized Data Labels that show for a selected column

Hi,   I am looking for any help that can be given in creating data labels for a stacked bar chart where the data labels only display for a selected column, e.g. far righthand as below.   I am try...
Need Help
  • onurbmiguel_'s avatar
    onurbmiguel_
    3 years ago

    Hello 

    Try to use the transparency color code "#FFFFFF00", i don´t know if it works in all visuals but you can try:

     

    IF(SELECTEDVALUE('A Xaxis Sort1'[Statement-Date_Text])="SAAW", "Black", "#FFFFFF00" )

     

    Best regards

    Bruno Costa | Solution Supplier

     

    Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

    Take a look at the blog: PBI Portugal 

     

drcsjc's avatar
drcsjc
Frequent Visitor
3 years ago

Hi Bruno,

 

Thanks, a partial success but wondered if you had any ideas on why the grey (lowest catergory in each column stack) is keeping its labels in white for columns 1 to 12 and yet not 13. I used a colour measure as you suggested as follows:

 
1 Asset Class Colour = IF(SELECTEDVALUE('A Xaxis Sort1'[Statement-Date_Text])="SAAW", "Black", "RGBA(0, 0, 0, 0)")

 

'SAAW' is a text field title of final righthand column stack on the X-axis.

 

The measure is used in the fx for the Data Labels/Value for color.  With 'Format Style' = 'Field Value' and 'What Field should we base this on ?' = 'Asset Class Colour' the outcome can be seen below 

 

 

 

 

Any pointers to help me get rid of the white data labels in the columns 1-12? 

Thanks  

 

onurbmiguel_'s avatar
onurbmiguel_
Power Participant
3 years ago

Hello 

Try to use the transparency color code "#FFFFFF00", i don´t know if it works in all visuals but you can try:

 

IF(SELECTEDVALUE('A Xaxis Sort1'[Statement-Date_Text])="SAAW", "Black", "#FFFFFF00" )

 

Best regards

Bruno Costa | Solution Supplier

 

Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

Take a look at the blog: PBI Portugal