cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate V
Advocate V

Re: Sort the Order in the Stacked Bar chart

Nope i am getting the same error.

Highlighted
Super User III
Super User III

Re: Sort the Order in the Stacked Bar chart

Ops, i think now i understand the error message...

In your soultion you have more than one value in 'Sort' for the same value in 'IFCondition'.

 

I think your column IFCondition is part of the table 'Capability Data' and you create the Sort column in this way.

 

 

Sort = IF('Capability Data'[IFCondition]="Hard";3;
       IF('Capability Data'[IFCondition]="Medium";2;
       IF('Capability Data'[IFCondition]="Easy";1;0
       )))

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether

Highlighted
Advocate V
Advocate V

Re: Sort the Order in the Stacked Bar chart

Hi ,

 

I got the solution , i tried to create separate measures for hard,medium and easy and use them in Value box and arrange these measures as added so that it sorts the column charts as required.Chart.jpg

 

View solution in original post

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors