Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Python Slicer with New Parameter

Hey guys!   The goal of my visualisation is to get a slicer, that can filter my Python-visualisation of maxCurrentCutter and maxCurrentNormal. These two are columns in the table testDataCutter (scr...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    I think I found an appropriate solution. 

     

    In the Power Query Editor, you have to convert the two columns (maxCurrentCutter & maxCurrentNormal) in into a Unipivot Column. Than you can select between maxCurrentCutter & -Normal in a slicer which will also affect the python code. 

     

    The only problem with this method is, that the number of rows doubles, which can lead to performance issues on larger datasets.

     

    Hope this helps somebody 🙂

     

     

    from this...

     

     

     

     

     

     

     

     

     

     

    to this ...

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I think I found an appropriate solution. 

 

In the Power Query Editor, you have to convert the two columns (maxCurrentCutter & maxCurrentNormal) in into a Unipivot Column. Than you can select between maxCurrentCutter & -Normal in a slicer which will also affect the python code. 

 

The only problem with this method is, that the number of rows doubles, which can lead to performance issues on larger datasets.

 

Hope this helps somebody 🙂

 

 

from this...

 

 

 

 

 

 

 

 

 

 

to this ...