Forum Discussion

JemmaD's avatar
JemmaD
Helper V
2 years ago

Creating custom text data labels for chart

I have a stacked column chart which holds two categories: Focus and Strategic. The values in the stacked are basicaly Yes and No for these two options.  I am trying to create a custom data label whi...
Need Help
Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

Hello JemmaD ,

 

can you try creating it as a calculated column with the following formula

Data Label = 
SWITCH (
IF (  'Broker Type'[Broker Type] = "Focus"  &&   'Broker Type'[Count] = "Y"  , "Focus"  ,
IF (  'Broker Type'[Broker Type] = "Focus"  &&  'Broker Type'[Count] = "N"  , "Non-Focus"  ,
IF (  'Broker Type'[Broker Type] = "Strategic"  && 'Broker Type'[Count] = "Y"  , "Strategic"  ,
IF (  'Broker Type'[Broker Type] = "Strategic"  &&  'Broker Type'[Count] = "N"  , "Non-Strategic" ) )))

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

  • JemmaD's avatar
    JemmaD
    Helper V
    2 years ago

    A calculated column cannot be used as a data label it needs to be a measure.