Skip to main content

Power BI

New

Test Idea 1

Vote (1) Share
Sonali Gupta's profile image

Sonali Gupta on 30 Nov 2021 07:32:04

What is Lorem Ipsum?


Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum

Comments (13)
Sonali Gupta's profile image Profile Picture

Sonali Gupta on 09 Feb 2022 06:21:44

RE: Test Idea 1

Hi, It will be great to have this feature indeed. As a workaround I use the custom conditional columns.You insert a new conditional column in the data table (I called it order by) Assign a number for each value in the desired column(column A) for which you want to assign the custom order. If you have 10 values you want to put in specific order you use the number from 1 to 10.Make sure your new column is with data type Number. Then close & apply the changes,Select the column (Column A) to which you want to apply custom order,Once you select the (Column A) on the top new tab Column tools will appear Select sort by and select the new column with the assigned number for the values in your column It works well for me as a workaround to sort and order everything the way I want to. The downside is that it is manually maintained.

Sonali Gupta's profile image Profile Picture

Sonali Gupta on 09 Feb 2022 05:48:47

RE: Test Idea 1

Hi, It will be great to have this feature indeed. As a workaround I use the custom conditional columns.You insert a new conditional column in the data table (I called it order by) Assign a number for each value in the desired column(column A) for which you want to assign the custom order. If you have 10 values you want to put in specific order you use the number from 1 to 10.Make sure your new column is with data type Number. Then close & apply the changes,Select the column (Column A) to which you want to apply custom order,Once you select the (Column A) on the top new tab Column tools will appear Select sort by and select the new column with the assigned number for the values in your column It works well for me as a workaround to sort and order everything the way I want to. The downside is that it is manually maintained. 

Sonali Gupta's profile image Profile Picture

Sonali Gupta on 08 Feb 2022 12:31:21

RE: Test Idea 1

You insert a new conditional column in the data table (I called it order by) Assign  a number for each value in the desired column(column A) for which you want to assign the custom order. If you have 10 values you want to put in specific order you use the number from  1 to 10.Make sure your new column is with data type Number. Then close & apply the changes,

Sonali Gupta's profile image Profile Picture

Sonali Gupta on 08 Feb 2022 12:16:34

RE: Test Idea 1

test1test2

Sonali Gupta's profile image Profile Picture

Sonali Gupta on 08 Feb 2022 12:15:03

RE: Test Idea 1

test1test2test3

Sonali Gupta's profile image Profile Picture

Sonali Gupta on 28 Jan 2022 07:20:36

RE: Test Idea 1

test

Sonali Gupta's profile image Profile Picture

Sonali Gupta on 11 Jan 2022 07:36:43

RE: Test Idea 1

test

Sonali Gupta's profile image Profile Picture

Sonali Gupta on 11 Jan 2022 07:24:21

RE: Test Idea 1

onclick=prompt(8)>

Sonali Gupta's profile image Profile Picture

Sonali Gupta on 11 Jan 2022 07:23:20

RE: Test Idea 1

onclick=prompt(8)

Sonali Gupta's profile image Profile Picture

Sonali Gupta on 30 Nov 2021 13:34:28

RE: Test Idea 1