Gillian_Watson
5 years agoNew Member
Status:
New
Define sort order at same time as creating a conditional columns
I am using a conditonal column to group durations (days) into custom groups "Range" eg less that 30 = less than 1 month else if less that 60 = 1 to 2 months else if less than 90 = 2 to 3 months otherwise = great than 3 months As my "Range" custom column is not text it does not sort in this order (instead alphabetically)- and cant sort the column by duration as that is not unique. So I know have to do another conditional column to specify sort order. Would be great if while constructing the first conditional column you could tick a flag to say - sort by this order. Or have an extra cell on each line so you could specify a sort order number as you go.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Fabric Copy Jobs desperately need basic editability after creation.
Requiring users to recreate an entire Copy Job just to change something as fundamental as the source connection or connection URL is unnecessarily restrictive and creates significant maintenance over...mpersha6 hours agoRegular VisitorNew3Views0likes0CommentsPreserve Background Colors When Exporting Power BI to Excel
When exporting a Power BI table or matrix to Excel, the data is exported correctly, but background colors and conditional formatting used to distinguish records are not preserved. It would be helpful...surya37 hours agoNew MemberNew4Views0likes0CommentsAdd an option to hide all visual-level filters
As a best practice, we often need to hide fields and measures from the Filters pane in Power BI reports. When a visual contains dozens of fields and measures, manually hiding each one individually ca...Roman20268 hours agoNew MemberNew21Views0likes2CommentsPower BI Table visual – "Show items with no data" causes blank values
A table visual groups only on columns (no measures) from a parent table and its child table, with "Show items with no data" on. For parent rows that have no child rows, the parent row appears, but an...ratcowboy9 hours agoNew MemberNew16Views1like0Comments