Forum Discussion
Access filters in Custom Visual
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
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?
I think that's impossible to achieve since columns must be specified at Fields panel.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
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?
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
