Forum Discussion

ageuffrard's avatar
ageuffrard
Frequent Visitor
4 years ago
Solved

Graph don't display the same data than the table

Hi everyone,  This is my dashboard in Power BI :    I got clients related to "polices" in Excel, like this : Client_A -> Police_1 Client_B -> Police_1 Client_B -> Police_2 Client_C -> Poli...
Need Help
  • NickolajJessen's avatar
    NickolajJessen
    4 years ago

    Hi,

    Create a table called NumberOfPolicies (Or whatever)

    then
    1. Create a Column chart
    2. Put NumberOfPolicies[Value] on X-Axis
    3. Put CountCustomersWithXPolicies measure on Y-axis

     

amitchandak's avatar
amitchandak
Super User
4 years ago

ageuffrard , Not very clear Why police 1 = 10 wrong and 4 is correct

 

do you need a distinct count

 

distinctcount(Table[client])

ageuffrard's avatar
ageuffrard
Frequent Visitor
4 years ago

Hi amitchandak , in my table on the right, there is 4 values equals to "1", 3 equals to "2", 2 equals to "3" and 1 equals to "4".
I want to do a graph (column chart) where the x-axis corresponds to the "Number of Police" like this :

Problem is I can only get my column "number of police" thanks to this option :

I’m not comfortable with Dax so i struggle a bit.