Forum Discussion

daustin's avatar
daustin
Frequent Visitor
9 years ago
Solved

SSAS Sort By Column Causing Data Cannot Display Visual Error

Power BI does not seem to understand SSAS attributes that have an order by attribute assigned to them.  When attempting to build a visual, it will X itself out and say that it cannot be displayed.   ...
  • daustin's avatar
    daustin
    9 years ago

    I could not get VARCHAR types to sort in my Store Dimension only in Power BI, but if I use Integers it works.  I was able to sort attributes in different dimensions using the VARCHAR type.  It wouldn't work in the Store Dimension even after rebuilding.  Integers it is.

daustin's avatar
daustin
Frequent Visitor
9 years ago

Still haven't figured it out.  I'll keep talking to myself here.

 

My time dimension sorts just fine and I don't know how to replicate that behavior.

daustin's avatar
daustin
Frequent Visitor
9 years ago

I could not get VARCHAR types to sort in my Store Dimension only in Power BI, but if I use Integers it works.  I was able to sort attributes in different dimensions using the VARCHAR type.  It wouldn't work in the Store Dimension even after rebuilding.  Integers it is.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I have the same problem. Integer works okay but sorting with an attribute varchar is giving problems.