Bar Chart - Same variable but multiple time in X-axis

[Anonymous]

I am a newbie in this Power BI software and downloaded two days back. Actually I have two columns, one is "Type" (nominal data) and the second one is "Speed" (numerical data/measure). Some Type can repeat itself like Type1 when run the first time it gives Speed of 2, but when it was run the second time it gave Speed of 3. Whenever I am trying to produce a bar chart, instead of showing type1 with their Speed separately, it is giving me the same type with the sum of Speed. In this case Type1 resulting in 5 (Sum of Speed). How can I present type1 multiple times in the x-axis of a bar chart with their respective speed in the y-axis?

Thanks in advance. 

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Unless you mark duplicate types separately, they will be aggregated.

Column = 
VAR x = 
RANKX(
    FILTER(
        Sheet2,
        Sheet2[Type ] = EARLIER(Sheet2[Type ])
    ),
    [Speed], ,ASC, Dense
)
RETURN
[Type ] & "(" & x & ")"

Best regards,
Lionel Chen

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

[Greg_Deckler]

So, sample data and expected output would assist greatly. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

But, a couple things to try. Perhaps try setting Speed to "Do not aggregate". Doubt that will work in the case of a bar chart.

Second thing to try, if you have something that identifies a Type1 as unique, put it in your Axis hierarchy above "type" and then drill into the hierarchy using the forked arrow icons.