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
    7 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.

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

Hi JulienSchanen 

What final output do you want?

As tested, you could create measures to return data as function- Table.profile() does

It can change according the "drop down" slicer.

 

As teste, i can create a frequency histogram as below.

Please share some example data or expected result so i can help you to get the result.

 

 

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
      7 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

        It's working

         

        Thanks a lot for the solution Maggie