powerbi - How do I create a bar plot histogram of a parameter in power BI - Stack Overflow

admin管理员组

文章数量:1124549

I'm trying to create basic descriptive visualizations for my dataframe, such as histograms, but since there are a lot of variables I'd like to make 4 histograms for which you can select the display variable.

My usual approach to a histogram is a clustered bar plot where x-axis is the variable and y-axis is the variable count.

I've tried to make the same thing with a field parameter:

Create a field parameter of single selection, with all possible numeric variables, "VAR" -> Put "VAR" as x and y axis in a clustered bar plot.

This, however, yields an empty plot, and I don't have the count option for the field variable (or any other basic operation).

Here is some dummy data:

VarA	VarB	VarC
4	6	673
22	5	774
64	0	672
62	5	335
29	3	850
27	9	202
56	2	305
100	0	383
32	5	545
22	9	1000
86	7	170
95	9	91
35	8	995
30	4	51
53	7	802
88	8	321

I'm trying to create basic descriptive visualizations for my dataframe, such as histograms, but since there are a lot of variables I'd like to make 4 histograms for which you can select the display variable.

My usual approach to a histogram is a clustered bar plot where x-axis is the variable and y-axis is the variable count.

I've tried to make the same thing with a field parameter:

Create a field parameter of single selection, with all possible numeric variables, "VAR" -> Put "VAR" as x and y axis in a clustered bar plot.

This, however, yields an empty plot, and I don't have the count option for the field variable (or any other basic operation).

Here is some dummy data:

VarA	VarB	VarC
4	6	673
22	5	774
64	0	672
62	5	335
29	3	850
27	9	202
56	2	305
100	0	383
32	5	545
22	9	1000
86	7	170
95	9	91
35	8	995
30	4	51
53	7	802
88	8	321

And here is what I've tried to do with the data: On the left are the 3 individual "histograms" (yes they look bad but that's another whole issue), and on the right a clustered bar plot with its x and y variables as "FIELD PARAMETER", the field parameter I created (also on the right). As you can see, it yields a blank plot.

• powerbi

Share Improve this question Follow edited 2 days ago Sam Nseir 11.6k22 gold badges44 silver badges2020 bronze badges asked 2 days ago Théodore TargerianThéodore Targerian 6344 bronze badges 2

• 1 Please provide sample/dummy data, just enough to demonstrate what you are wanting to achieve, along with screen snips/sketches etc... Update your question with this, and provide sample data in markdown format – Sam Nseir Commented 2 days ago
• @SamNseir just did, thanks for the feedback – Théodore Targerian Commented 2 days ago

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

Create a Measure similar to:

# rows = COUNTROWS(YourTable)

Use this for your Y-axis, and the Field Parameter for your X-axis.

本文标签： powerbiHow do I create a bar plot histogram of a parameter in power BIStack Overflow