Forum Discussion

CTH2022's avatar
CTH2022
Frequent Visitor
4 years ago
Solved

Label on stacked column chart

Have the following data set.   Apple 10 Orange 20 Mango ALL   How to show ALL as label on the chart?
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi CTH2022 ,

    I updated the sample pbix file(see attachment), please check whether that is what you want. You can update the formula of Measure as below, the part with red font is updated ones....

    Measure =
    VAR _fruitswithall =
    CALCULATETABLE (
    VALUES ( 'Table'[Fruit] ),
    FILTER ( 'Table', 'Table'[Type] = "ALL" )
    )
    RETURN
    IF (
    SELECTEDVALUE ( 'Table'[Fruit] ) IN  _fruitswithall,
    "ALL",
    CONCATENATE ( [Count], "" )
    )

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi CTH2022 ,

I updated my sample pbix file(see attachment), please check whether that is what you want.

1. Create a measure as below

Measure = IF(SELECTEDVALUE('Table'[Fruit])="Mango","ALL",CONCATENATE([Count],""))

2. Create a Infographic Designer visual

3. Set the text and bind to the new created measure in previous step just as below screenshot

In addition, you can refer the following thread to get it.

Power BI - Visuals that support custom data labels like Tableau

Best Regards

CTH2022's avatar
CTH2022
Frequent Visitor
4 years ago

The measure works only if we know the data for Mango is "ALL" . Can this measure be changed to  work on any kind of fruit as we can not sure which one will have "ALL" in the entry.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi CTH2022 ，

    Can I know the backend logic of "ALL"?  When and which the label of fruit need to dispaly as "ALL"?

    Best Regards