three bar chart from same column

[MaliniBaktha]

Hi, 

I have a column with numbers, I have to create three bar charts (minmum, average and median) from the values using that column. But when I try to do that the bars gets attached to each other.  The bars are attached to each other leaving big space in the left and right side, is there a way to give space between the bars . I did try creating (average, median and minimum as a separate measures as well but nothing is working. Any suggestions in this ?

[Ritaf1983 · Accepted solution]

Hi @MaliniBaktha 

This is happening because you don't have an X-axis.
You just put 3 different measures.

To get the graph you can generate a table of your measures, please follow these steps.

1. Create blank table with a column with your measures :

2. Regular measures of what you need

average = AVERAGE('Table'[Value])

median = MEDIAN('Table'[Value])

average = AVERAGE('Table'[Value])

3. Create dynamic measure in the new table

bar measure = if (SELECTEDVALUE('measures table'[Measure])= "Minimum" ,[minimum],

if (SELECTEDVALUE('measures table'[Measure])="Median",[median],[average]))

4. Put column "measures column" from the new table on x axis and "bar measure" on Y:

Link to a sample file 

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

[Ritaf1983 · Accepted solution]

Hi @MaliniBaktha 

This is happening because you don't have an X-axis.
You just put 3 different measures.

To get the graph you can generate a table of your measures, please follow these steps.

1. Create blank table with a column with your measures :

2. Regular measures of what you need

average = AVERAGE('Table'[Value])

median = MEDIAN('Table'[Value])

average = AVERAGE('Table'[Value])

3. Create dynamic measure in the new table

bar measure = if (SELECTEDVALUE('measures table'[Measure])= "Minimum" ,[minimum],

if (SELECTEDVALUE('measures table'[Measure])="Median",[median],[average]))

4. Put column "measures column" from the new table on x axis and "bar measure" on Y:

Link to a sample file 

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

[MaliniBaktha · Accepted solution]

You are cool this wroked fine. I did the same before but made it wrongly 

[Ritaf1983]

Happy to help 😊