Forum Discussion

JulienSchanen's avatar
JulienSchanen
Regular Visitor
7 years ago
Solved

Histogram - Data Quality

Hello,   I'm a new user of Power BI desktop. I'm trying to create a data quality report and I want 3 elements : - A table with information from each of my columns (for that I used Table.profile() ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi JulienSchanen 

    We can't change the columns added in the "Axis" field of the column chart.

     

    One workaround is as below

    Assume you have data as below

    Add an index column from 1 in Edit  queries

    then click on "index column", unpivot other columns

    Close &&apply

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

JulienSchanen's avatar
JulienSchanen
Regular Visitor
7 years ago

Hello v-juanli-msft 

 

Thanks you for your help !

 

I want that kind of output :

 

 

And when I changed the field to analyze, I want an automatic update of the histogram below with the frequency of the chosen field.

 

Best regards,

Julien

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi JulienSchanen 

We can't change the columns added in the "Axis" field of the column chart.

 

One workaround is as below

Assume you have data as below

Add an index column from 1 in Edit  queries

then click on "index column", unpivot other columns

Close &&apply

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • JulienSchanen's avatar
    JulienSchanen
    Regular Visitor
    6 years ago

    It's working

     

    Thanks a lot for the solution Maggie