Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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 r...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    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's avatar
Greg_Deckler
Community Champion
6 years ago

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.