Create a table inside a measure and use a column in that table on the X-Axis of a bar chart

[Anonymous]

Hi,

I intend to create a table inside a measure. After getting the relevant columns from the original table (existing in the data model), I plan to add a column that can be used to group in the visual

(eg. I intend to use groups like

Sales > 1000,

Sales >5000, etc.)

My question is whether the above created column can be used on the X-axis on the bar chart? (Since the table will be dynamically created based on the external filters)

[Anonymous]

Hi @Anonymous .

I do not think you can use a measure as a dimension as you describe.

But, I am curious if others on the forum has a good solution for you! 🙂

One approach you may consider is to create a separate table based on you original table that calculates the desired grouping. The drawback of this solution may be some duplicate data, additional complexity.

[Anonymous]

hi @Anonymous ,

I did think of it, but the different filter combinations are too many to actually implement it. 

But thanks for giving the query a thought 🙂