Power BI
Needs VotesFixing power bi Embedded JS SDK Tuple filter allowing filtering two Columns inside the same table.
Jossef on 22 May 2020 03:29:56
In the documentation it is mentioned that the is a special filter exactly for that call 'Tuple' filter which allow us to filter multiple columns within the same table when using the custom visual hierarchy slicer :
https://www.youtube.com/watch?v=DW5NZHTZlPw
Tuple filter documentation: https://github.com/Microsoft/PowerBI-JavaScript/wiki/Filters
The custom visual hierarchy slicer works just fine but when i have try to use the Tuple filter it turns out it is not really supported.
When you apply the filter to the slicer with the js sdk code it keeps returning errors, saying the filter is not valid.
I have contacted the support team (who where very willing to help) and re-produced the errors with them,
eventually the official answer form the product team was that that they are not going to issue a fix for the Tuple filter.
The only why for them to provide a fix is :
1. A request of a Premium account owner (5k a month plan) who can demand for a fix.
2. If we get 500 votes on the 'offer a ' community page.
If you are having the same issue or plan to filter multiple columns within the same table using the PowerBI-JavaScript SDK I will appreciate your vote!
https://github.com/Microsoft/PowerBI-JavaScript/wiki/Filters
here is an example of a tuple filter that select ata from colums A and B that are stored in the same table - table A
slicer_Tuple_Filter = {
$schema: "http://powerbi.com/product/schema#tuple",
target: [
// same table different columns selection
{table: Table A", column: "column A"},
{table: "Table A", column: "column B"} // same table different columns selection
],
filterType: 6, // can be int 6 or string 'Tuple'
operator: "In",
// value for selected columns
values: [
[ {value: "value1"}, // value for column A
{value: "value2"}// value for column B
]
]
};