Forum Discussion

Martijnkamps's avatar
Martijnkamps
Regular Visitor
9 years ago
Solved

Filtering and Count issues

Hi everyone,   I am new to Power BI and look to solve the following problem:   I have a table of strings that looks something like this:   Column 1              Column 2 A                     ...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    Hi Martijnkamps,

     

    If you add the column 1 and column 2 to a table or matrix visual you will get the first two columns on your example, please make sure you have it as don't summarize, then just add the column 2 again and choose the option count and you will get the desired visual check print below.

     

     

    You can also put it in a graph but be sure to put column 2 in the legend:

     

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
9 years ago

Hi Martijnkamps,

 

If you add the column 1 and column 2 to a table or matrix visual you will get the first two columns on your example, please make sure you have it as don't summarize, then just add the column 2 again and choose the option count and you will get the desired visual check print below.

 

 

You can also put it in a graph but be sure to put column 2 in the legend:

 

 

Regards,

MFelix