I want to pass a table to a python visualization in powerbi. I am always passing two KPI's at all times. Eg: KPI_0 and a second KPI.
At the moment my current solution is to have two items selected from the slicer.[Current solution tab]
However, I would like it to improve it so that KPI_0 is always selected by default. This way the user only has to choose a second KPI.
I have made an attempt where KPI_0 and the second KPI is seperated into two tables with different column names.
However combining the two tables did not bring any benefit [Attempt1 tab].
In my second attempt, I have combined the two tables using power query and seperated the KPIs into seperate columns. However when using two slicers for the two columns, the slicers are working as 'AND' logic rather than 'OR' logic. i.e. when KPI_0 is chosen KPI_1 is blank and vice versa.
How can I always have KPI_0 selected and have the use choose only KPI_1 or KPI_2 only?
I have attached the source file here.