Forum Discussion

Benedikt42's avatar
Benedikt42
Frequent Visitor
4 years ago
Solved

Number of values, despite multiple selection in data source

Hello all,

I have not been working with Power BI Desktop for long, but I am now facing a problem.


In my Power BI, a database is used as a data source.

In the database, I enter persons and values or I can click on values. In a certain input field, I can select several values at the same time.

In Power BI, I want to count how many times a value has been selected in total, but the exact selection in the field in Power BI is currently selected at the individual persons.

This then looks like this:

 

 

As you can see, some terms show up on multiple bars.

 

Can you help me how to count only the individual terms, how often they were selected in general?

Here is an example of how it should look:

 

 

Thank you very much for your help.

Many greetings

 

Benedikt

  • Hi Benedikt42 ,

    In Power BI, when using the slicer, you can also select multiple values, hold down the ctrl value, and then click on the selected value in the slicer.

    refer:

     

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

2 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support

    Hi Benedikt42 ,

    In Power BI, when using the slicer, you can also select multiple values, hold down the ctrl value, and then click on the selected value in the slicer.

    refer:

     

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien