0 votes
1 view
in BI by (15.1k points)

I've built a new worksheet that has two dimensions and several facts. When I try to sort on any column, it only seems to sort within the dimensions. Is it possible to sort based on the column, ignoring dimensions? I find if I concatenate the two dimensions into one... that does work, but is not ideal.

enter image description here

2 Answers

0 votes
by (41.2k points)

0 votes
by (41.2k points)

Once you have created a bar chart, click on the measure or dimension on which you want to sort. (bar chart below without sort)

The selected pill is highlighted in a darker shade, then right click and select sort.

A dialog box opens as below.

Then select field option from the drop down from sort by option. (bar chart after sort below)

Then select the required field (Dimension/Measure) and the aggregation function. 

Once you apply the sort. You can see the sort image next to the measure or field on which sort is applied.

You can edit the sort in the same way in above steps.

You can clear sort by right clicking field and click on clear sort option.

Hope this helps you.

Welcome to Intellipaat Community. Get your technical queries answered by top developers !