topic Re: Label on stacked column chart in Developer

Label on stacked column chart

CTH2022 — Tue, 05 Apr 2022 07:41:33 GMT

Have the following data set.

Apple 10

Orange 20

Mango ALL

How to show ALL as label on the chart?

Re: Label on stacked column chart

Anonymous — Fri, 08 Apr 2022 03:48:13 GMT

Hi @CTH2022 ，

The label of the stacked column chart requires the value of the numeric type, and obviously the field with the value "ALL" is a Text type field. We can put this field under the Legend option. This is shown in the figure below.

In addition, you can refer the following thread.

Stacked column chart with text as data labels

If the above one can't help you get the desired result, please provide some sample data refer in your stacked column chart with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

How to upload PBI in Community

Best Regards

Re: Label on stacked column chart

CTH2022 — Tue, 12 Apr 2022 00:57:40 GMT

Hi, Attached a picture to clarify the question. Is the a way to display "ALL" for items with "ALL" as entry in coulmn B? Or is there is better visual that can be used for this kind of situation?

Re: Label on stacked column chart

Anonymous — Tue, 12 Apr 2022 07:23:56 GMT

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

Re: Label on stacked column chart

CTH2022 — Thu, 14 Apr 2022 09:08:16 GMT

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.

Re: Label on stacked column chart

Anonymous — Thu, 14 Apr 2022 09:34:46 GMT

Hi @CTH2022 ，

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

Best Regards

Re: Label on stacked column chart

CTH2022 — Thu, 14 Apr 2022 13:39:38 GMT

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?

Re: Label on stacked column chart

Anonymous — Fri, 15 Apr 2022 02:45:59 GMT

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

Re: Label on stacked column chart

CTH2022 — Fri, 15 Apr 2022 06:51:52 GMT

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