Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Table Column as Slicer

Hey guys!

 

As you can see on the screenshots below, I've created a scatter plot with maxCurrentCutter and maxCurrentNormal as values with python script, because I want the date on the x-axis.

 

Now I want to filter the plot after maxCurrentCutter and -Normal with a slicer (in python you can't just click on the legend becuase it is not interacitve so I have to do it with a slicer). 

 

But the problem is, 'maxCurrentCutter' & -Normal' are columns in the 'testDataCutter' table. This means that when I transfer these two column names to a slicer, all the values of the respective category (e. g. 6. 4, 3. 7,  . . . ) are on the slicer and not their names themselves.
 
Is there a way to create such a slicer? Or any other possiblity?
 

 

Best regards,

Dominic

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

     

    Maybe you can try to use the Field parameter.

    First of all, you should open the Field parameter in the Options > Preview features.

    Then restart the power bi and you can use the field parameter in the Modeling pane .

     

    Here's the link which can help you:

    Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thanks Anonymous, that helps but I do not know how to implement the field parameter in the python Code. But I hope I figure it out.