Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a datatable with air pollution readings.
"Wind Dir" is derived from the column "Dirección" (which contains the direction in degrees) by using a "bucket table" / lookup table.
Wind Dir = IF (ISBLANK(factSanSeb[Dirección]);BLANK(); CALCULATE( VALUES(WindDirection[Direction]); FILTER(WindDirection; factSanSeb[Dirección] >= WindDirection[Low] && factSanSeb[Dirección] < WindDirection[Hi]) ) )
I have added "WindDirOrder" column (N = 1, NE = 2, E = 3, etc using an unrelated lookup table) to be able to sort column "Wind Dir", which does not seem to work in the bar charts and radar chart.
Any suggestions? Cheers, Julian
Solved! Go to Solution.
Hi @v-shex-msft ,
Finally got it to work.
My problem was the added Calculated column X (with the sort order) depended on another Calculated column Y which I wanted to sort by X.
Cheers, Julian
Hey,
I guess this is what you are looking for: https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-butto...
Please be have a look for the section "Sort using the Sort by Column button" on the above mentioned site. You have to order the columns in the table that you are using in your visuals.
Regards,
Tom
Guten Abend Tom,
I keep getting a message "Sorting on a different column: This column cannot be sorted by a column which has already (direct or indirect) been sorted by this column."
My sort by column is a calculated column. Not sure if this is important.
Cheers, Julian
HI @jjr333 ,
You can create a calculate table to achieve this, please refer to following blog to know more about this:
Please understand that this link is provided with no warranties or guarantees of content changes, and confers no rights.
Regards,
Xiaoxin Sheng
Hi v-shex-msft,
Thank you, unfortunately I still can't get it to sort properly.
It sorts the column "Wind Dir" in the fact table alphabetically.
"Wind Dir" in the fact table is a calculated column, not sure if this is of importance.
J.
support table, for sorting
fact table
relationships
HI @jjr333 ,
You need to extract category value from fact table and add index field, then configure 'sort by column' feature on new table category fields and create relationship.
After these steps, You can use custom sort table fields to replace original table column fields.
BTW, I don't think it is possible to custom direction axis for radar chart.
Regards,
Xiaoxin Sheng
Hi @v-shex-msft ,
Finally got it to work.
My problem was the added Calculated column X (with the sort order) depended on another Calculated column Y which I wanted to sort by X.
Cheers, Julian
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |