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

- A dropdown list to select just one field (based on the table created by table.profile)

- And an histogram to show the frequency of each results for the selected field

 

But I don't know how to link the dropdown and the histogram to show only data from the selected field in the histogram 

 

Thanks you for your help

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.

4 Replies

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