Unable to use a measure as an axis and unable to group measures

[mr_reygan]

Hi,

I am attempting to mirror an excel chart in Power BI.

I have the following data. The last 2 columns are measures and dependent on a slicer.

I am trying to produce the chart below.

However, I am not able to use Sales Volume Grouped (Measure) as an axis. How can I achieve this?

Also, is there no option for me to group Sales Volume (Measure)? I had to create if statements to produce the values in Sales Volume Grouped (Measure).

[Anonymous · Accepted solution]

Hi @mr_reygan ,

Based on your description, you can do some steps as follows.

Here is my test table.

Sales Volume = MAXX(FILTER('Sheet1',[Make]=SELECTEDVALUE(Sheet1[Make])),[Sales])

Sales Volume Grouped = IF([Sales Volume]<=99,"0-99","100-9999")

1. Create a calculated column.

Sales Volume Grouped_column = IF([Sales]<=99,"0-99","100-9999")

1. Create a new calculated table including a column that consisting of “0-99”and “100-9999”.

   

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

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

[mr_reygan]

Hi,

Sorry, I am new to calculated tables. Below is what I see. What should be my formula?

[Anonymous]

Hi @mr_reygan ,

You can use "SUMMARIZE()" function to create a table or just choose "Enter Data" to create a new one.

Hope that's what you were looking for.

Best Regards,

Yuna

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

[Ashish_Mathur]

Hi,

This can be done.  Share the link from where i can download your PBI file.

[HotChilli]

You can't put a measure on the axis.

You could create a calculated table with column for Sales Volume and use the Grouping/Binning features to create the last column.

[mahoneypat]

To do that, you need to make a disconnected table with 0-99 and 100-999 as rows.  Also have two other columns that have 0 and 99 and 100 and 999, respectively.  You can use the first column as your axis, and make a measure that uses the other two columns in the evaluation.

Regards,

Pat