Hi there EDNA forums.
I have this common analysis scenario where I have a continuous variable that I need to group and segment, to then use this grouping as a dimension in a chart. The switch statement makes the first part possible
however this cannot be used in the visual.
I am aware of this discussion Measure on X-Axis and also this technique
but this is not possible as I connect to a PBI data model and all create new tables, create new columns are greyed out.
Has anyone a workaround for this?
Options I have looked at / thought of are:
- Searched PBI visual market place to see if a non-standard viz allows this behaviour - couldn’t find one
- I could potentially introduce a dummy supporting table as per the EDNA video linked to above, but I need a way to overwrite the values/grouping bands that would be built into the model as this data model is shared by 300 clients and their band labels and min-max would be different on a client by client basis. Not sure how.
- someone mentioned calculation groups may be a way to change measure behaviour but not sure how.
Any other suggestions/solutions here?