Access filters in Custom Visual

[aarshps]

Hi,

I have a custom visual in which I need to access the page filters that are being applied. How can I get the filters from my Custom Visual code?

I am trying to create a custom visual somewhat similar to MAQ software's JSONGrid Viz. I also need to add an additional functionality of have a filter element to control the number of columns in the Viz. That is there will be a multiselect to select the columns for the table.

I'm fairly new to Power BI.

[v-chuncz-msft]

@aarshps,

You may take a look at Using the advanced filter API and view source code of JSON Grid at https://github.com/maqsoftware/PowerBI-visuals/tree/master/src/CustomVisuals/Published/JSONGrid.

[aarshps]

I have been looking into the source code.

My doubt is how can I have a multi-select like thing in my application and let the user select a list. Then the visualization that is created should have only the columns in the list selected by the user.

[v-viig]

Power BI Custom Visuals API doesn't support the ability to get filters that are applied on the page.

Could you please explain the second feature a bit deeper?

I also need to add an additional functionality of have a filter element to control the number of columns in the Viz. That is there will be a multiselect to select the columns for the table.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[aarshps]

Please click to see the image

I've attached a link to what I would like to achieve. Based on that multi-select present just beside the visual, the columns need to change dynamically. So what I need to have is the selections from the slicer to the custom visual.

I need to get the values selected for the slicer inside the custom visual's update(). Will I be able to do it?

[v-viig]

I think that's impossible to achieve since columns must be specified at Fields panel.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[aarshps]

Thank you for letting me know. But still, I could achieve the same using a matrix visualization. My doubt is, will I be able to achieve it with custom visuals? Somehow? Even the solution might not look clean, can it be done?

[jppp]

The behavior you describe is default behavior of Power BI: the dataset available in your (custom) visual is already filtered by other filters from the Power BI. So if you filter on one column, only that column is available in your visual. And if you change that slicer that columns (name and values) are available.

Just try and create a 'simple' empty custom visual only with the dataRoles and dataViewMapping defined and look at the data view of the developer visual to see what dataset is available.

-JP