Is it possible to create a custom distribution report which shows the different amount fields?

[Anonymous]

Hi,

I have a requirement to create a table visual showing different amount columns/fields( charges, payments and adjustments) based on different categorical fields/columns like department, location etc. The amount are single select and multiselect, if no amount is selected then the tableshouldnt appear. 

Is there any way to achieve this using custom visuals from appstore?

[Anonymous · Accepted solution]

HI @Anonymous,

#1, You can do unpivot column on your value fields to convert them to attribute and value, then you can use the attribute field on slicer to accurately control what type of value fields display on your visual.

Unpivot columns (Power Query) 

Dynamic Attributes In A Power BI Report 

#2, Currently, you cannot directly use a filter to control the visibility of visuals. (you can filter on it to show blank visual contents but can't hide it)

Perhaps you can take a look at the following blog to create a card visual to mask the raw visual based on selection:

Show or Hide a Power BI Visual Based on Selection 

BTW, you can also create a script-based visual to plot your graph, it can be process based on its script and conditions. (these type of visual can't interact with other visual but they can receive the filter/interact from other visuals)

Regards,

Xiaoxin Sheng