Forum Discussion

JSJB's avatar
JSJB
Helper I
3 years ago
Solved

Add a data field that does NOT impact visual

Hello,   I need to implement a sort of "choices" menu for inputting data in a Power BI custom visual. All of the functionality is implemented, by which I mean generating the dropdown, populating it...
  • dm-p's avatar
    dm-p
    3 years ago

    I think that with measures, you only get the ability to choose the actual measure at the top-level and not any specific values, as this is how selectors work. I would anticipate that you would get the same functionality as the core maxtrix visual's properties, e.g. if I have two measures in my matrix data view I get the following in the properties pane:

     

     

    I can't do anything with the measure values here, just configure properties at a measure level.

     

    With the categorical mapping you can get distinct group or series values, but I don't think that the matrix mapping has similar levels of aggregation when it comes to selectors.

     

    I'm of the opinion that you're going to have to ask the custom visuals team for the functionality you're looking for, as this still would involve adding a secondary dataset to the visual, which is currently not possible.

dm-p's avatar
dm-p
Super User
3 years ago

Hi JSJB,

 

Because visuals only get one query, adding disconnected data will have an effect on your visual's data view. If you cannot match the desired granularity of this query by adding non-related data and remove it when processing into your viewmodel, one option would be to somehow post-process the data view to split out the components and recreate your desired datasets in your viewmodel processing. This is far from ideal, as you cannot guarantee how a user's measures will behave and you will not be able to guarantee the aggregation (or internal logic) as this is not exposed to the data view.

 

The only other option based on current functionality would be to create a scalar measure of your dimension data that is flattened (e.g. through CONCATENATEX or similar) and create a conditional formatting property for it that the user can add themselves. You will need to deseralise this in your visual's code and render what you want from it.

 

There's currently no other way to get disconnected data into the data view, so if the conditional formatting approach can work, you'll need to ensure that you rusers understand this requirement in order to use your visual correctly.

 

Regards,

 

Daniel