Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Gurus,
I have a below metris which I want to share in a way that names of the latest(2021) year besome the first row of the matrix and name if the last year (2025) become the last row of the matrix
for instance SGE S18, Caves Creek and SGE S18, Lens AB should be the first row of the matrix, GBO Expansion should be second row of the matrix, Caves Creeks Floodplain should be the third row of the metrix and so on.. when I sort by facility it does not give me the desire result, it must be something of a custome sort to achieve this (what I think anayway)
is there any way I can achieve this.
Solved! Go to Solution.
Hi @amalrio ,
Based on your description, you can create a rank column as follows and sort by it.
Rank =
if(
[2021]=BLANK(),
IF(
[2022]=BLANK(),
IF(
[2023]=BLANK(),
IF(
[2024]=BLANK(),
"5",
"4"
),
"3"
),
"2"
),
"1"
)
Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @amalrio ,
Based on your description, you can create a rank column as follows and sort by it.
Rank =
if(
[2021]=BLANK(),
IF(
[2022]=BLANK(),
IF(
[2023]=BLANK(),
IF(
[2024]=BLANK(),
"5",
"4"
),
"3"
),
"2"
),
"1"
)
Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@amalrio , You have to create a new sort column based on the order you want
new column
Facility 1 = [Facility 1]
Facility sort = Switch( True(),
[Facility] = "SGE S18, Caves Creek",1 ,
[Facility] = "SGE S18, Lens AB ",2 ,
// add others
,6 //default value
)
Mark Facility sort as the sort column for Facility
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Hi, @amalrio
You can click on the column heading again so that the row labels can be sorted in descending order.
If you need customized sorting, you can add an index column to the data source as a sort sequence. For example, SGE S18, Caves Creek and SGE S18, Lens AB corresponds to a value of 1, and then you can use "sort by column" to achieve this.
Mark this post as solution if this helps, thanks!
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |