topic Re: Measure: change the category name in a bar chart in DAX Commands and Tips

Measure: change the category name in a bar chart

ambillate — Thu, 25 Mar 2021 09:25:47 GMT

Hi, Good Day.

Is it possible or is there a measure to change the names of the category in a bar chart?

without making a new column. (cause I don't have the access for editing the data source)

Like this example:

Thank You in advance.

Re: Measure: change the category name in a bar chart

Jihwan_Kim — Sun, 28 Mar 2021 06:17:24 GMT

Hi, ambillate

Please correct me if I wrongly understood your question.

Even you cannot access the original data source, I believe you can still change the columns' name in PBIX file.

Or, perhaps you can try to create a calculation-group and name each measure O, A, M, L. And then, you can pull the calculation-group to the X-Axis.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

Re: Measure: change the category name in a bar chart

Markus_Re — Mon, 29 Mar 2021 10:49:36 GMT

Hi ambillate,

I assume your table structure looks something like this (a very simplified version) :

As you can´t use a measure to return a table of values (and therefore use it as X-Axis), unfortunately it´s currently not possible to shorten the category name in your case without editing the underlying data.

Did this answer your question? Mark my post as a solution!

Re: Measure: change the category name in a bar chart

ambillate — Mon, 29 Mar 2021 13:53:47 GMT

uh, so it's not possible. Thank You Markus_Re and also to you Jihwan_Kim.. 🙂