Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
In a stacked column chart, I'm trying to change the order that the columns are displayed in. The labels are in text format because they are categories. I've tried sorting them by ascending and descending, but for some reason, the 6-12 category is recognized as the highest value. Anyway to change this so that it lists 0-6, 6-12, 12-24, and 24+?
Thank you,
Solved! Go to Solution.
Hi,
Try this
=RELATED(Category_order[Order])
Hope this helps.
Hi,
Try this
=RELATED(Category_order[Order])
Hope this helps.
When I select 'Create Column' in the Calculations tab, the new column appears and then disappears in the table where I'm trying to add it. Help.
Hi Ashish,
When I try to create a relationship between my base data column and the new category column, it says that i can't create a relationship because one of the columns must have unique values.
Hi,
In the Category_Order Table, there should only be unique entries in the Category column.
Hi @Anonymous,
You can try to create a calculated table with unique value as bridge table to link these tables.
Sample:
Bridge Table = DISTINCT ( UNION ( VALUES ( Table1[ColumnName] ), VALUES ( Table2[ColumnName] ) ) )
Regards,
Xiaoxin Sheng
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |