I am trying to use a field parameter on the Explain By input of my decomposition tree.
It is not working as I thought it would.
Firstly, why do I use a field parameter in the Explain By input?
I want the fields from the field parameter to be show in the drill into options when clicking the plus sign buttons.
There are some fields in the field parameter that are excluded for certain users by RLS or by certain selected values, so I don't want those fields to show up in the visual.
This works. Yey. Except...
The visual is not allowing me to pick the fields in the order that I want.
No matter which field I select to drill into next, it always (seems) to pick the next field in the order set in the field parameter order columns.
It also seems to get stuck after picking up to 2 or 4 dimensions, I'm not able to drill into more dimensions or to remove the already open dimensions using the cross sign button on top of the decomposition tree either.
In Power BI Desktop when trying to remove the field parameter from the Explain By input, I am getting an error and it won't be removed and need to remove the whole visual.
I published my report to the Power BI service to see if maybe it's just buggy in Power BI Desktop, but in the Power BI service it's also not behaving well.