Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
0970
Frequent Visitor

請問如何按順序進行「圖例排序」

1711943674713.jpg如圖,紅色框框,我希望呈現的值,可以按我的需求由「未發包」、「已發包」、「竣工驗收」順序排列。

我選遞減排序,出現「竣工驗收」「未發包」「已發包」,請問有解決辦法嗎?

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@0970 

你可以新建一個錶,如下圖,並且附上排序值

11.PNG

 

選中類型列,然後Sort by column排序列

 

12.png

 

把新錶和您的原錶建立關係

 

13.PNG

 

最後在圖形展示的時侯,用新錶的列來呈現就可以了

 

14.png

 

 

https://learn.microsoft.com/zh-tw/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
v-jiewu-msft
Community Support
Community Support

Hi @0970 ,

Many thanks to @ryan_mayu for your very quick and effective replies.

@0970 The next time you ask a question it can be in English.

If the above method is useful, you can accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Wisdom Wu

ryan_mayu
Super User
Super User

@0970 

你可以新建一個錶,如下圖,並且附上排序值

11.PNG

 

選中類型列,然後Sort by column排序列

 

12.png

 

把新錶和您的原錶建立關係

 

13.PNG

 

最後在圖形展示的時侯,用新錶的列來呈現就可以了

 

14.png

 

 

https://learn.microsoft.com/zh-tw/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Musadev
Resolver III
Resolver III

请检查此文本中的语法和拼写错误。请按照下表中所示为每个值分配数值:

"未发包",1
"已发包",2
"竣工验收",3

然后,在报告部分中,检查筛选选项,并在具体的可视化中,根据为文本分配的数字对数据进行排序。

如果您可以分享 PBIX 文件,我将检查度量和可视化以及其他实体。

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.