Forum Discussion
Label on stacked column chart
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" ))RETURNIF (SELECTEDVALUE ( 'Table'[Fruit] ) IN _fruitswithall,"ALL",CONCATENATE ( [Count], "" ))Best Regards
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?
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
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.
Hi CTH2022 ，
Can I know the backend logic of "ALL"? When and which the label of fruit need to dispaly as "ALL"?
Best Regards