Formating bar chart

[Anonymous]

So want to do the following. In visuals are by default and on the left the data number is above and it is black whereas on the right is white. However, when I go one level down on the same visual I got the following. They both shows data above and black. As I said this is by default I dint set up antything but I would like to set a different format based on the level. Like whie and within the bar whe I am in the first level but balck and data above when I go down one level.

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[Anonymous]

@Anonymous  What I understood based on all responses is that, right now it is impossible to do what I wanted to do so, Shall I accept that as a solution so my question get solved? I didnt really know either I should or not

[PaulDBrown]

@Anonymous 

Since there doesn't seem to be a solution currently to your predicament, I would suggest (on a lighthearted note) that you choose @Greg_Deckler  response (Rolling Stones' song link) as the (non) solution.

[Anonymous]

Hi @Anonymous 

I build a sample table to have a test. I build a Clustered column chart and change the data lable's color and position.

Result:

Currently, we can't custom the data lable's position and color for each level.

You can vote up your idea from this link to achieve this function: Idea

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@Anonymous , Seems like you are talking about data labels. Data label has the option "Position" to show outside, inside, Auto etc.

The color will typically depend on the theme, unless you choose one

[Anonymous]

@amitchandak  Yes I am talking about label I know I can change the colors and position but I was wondering I could set a specific color and position for one level and another for another level of data. Here the first image is level "Agosto" and data label is white. Then if I go one level down the data label change to black and data is out. However I di not set that up. Everything is on Automatically so I was wondering if it is possible to set up one configuration for "Agosto" and then another one for "sab-15"...and so on. The 2 images are the same visual.

 

[Greg_Deckler]

@Anonymous To the best of my knowledge you cannot have data label colors that are one color at one level and another at another level. I know that dev team is working hard to make most things conditional but data lables are not there yet in that visual. Once they are then you could do that. 

Question, what are you trying to achieve? Is there some sort of visual problem going on? Could you fix it by setting the background color and transparency for the data labels? Sorry, curious as to the reason.

[Anonymous]

@Greg_Deckler  There is no problem I just wanted to get it more customized 

[Greg_Deckler]

@Anonymous Sorry, a Rolling Stones song comes to mind...

[PaulDBrown]

@Greg_Deckler 

Offtopic warning!

"a Rolling Stones song comes to mind..."

Which is....? You need to include a reference/link!

[Greg_Deckler · Accepted solution]

That song would be the following. In particular at the 50 second mark

[PaulDBrown]

@Greg_Deckler

😁

[amitchandak]

@Anonymous , I think that is a color adjustment as the position is auto. Change position to outside end

[Greg_Deckler]

@Anonymous I am not quite following this, maybe some more screen shots? And we apparently have different definitions of black I think as I am seeing blue and kind of a greenish cyan type color.

[Anonymous]

@Greg_Deckler  I meant the data numbers not the bars itself sorry. As it is shown they are white and the I go down one level and it automatically change to black