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

CTH2022's avatar
CTH2022
Frequent Visitor
4 years ago

Say if  the data is updated as follow the next day, I want A:LL to be shown on Orange bar. Is there a way to change to measure to take care of this automatically?

  • Anonymous's avatar
    Anonymous
    Not applicable
    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

    • CTH2022's avatar
      CTH2022
      Frequent Visitor
      4 years ago

      Yes..This is what I wanted to to do. Thanks for the great hlep.