Histogram - Data Quality

[JulienSchanen]

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

[v-juanli-msft]

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]

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 · Accepted solution]

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]

It's working

Thanks a lot for the solution Maggie