Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Pikachu-Power
Post Prodigy
Post Prodigy

Compact Histogram

Hello everyone,

 

Maybe someone can give me an idea how to create a compact histogram in Power BI like following:

 

1.PNG

 

I have a lot of consumption values which i assign to different categories like

 

and so on...

-5.0 to -2.5 Percent

-2.5 to 0 Percent

0 to 2.5 Percent

2.5 to 5.0 Percent

and so on...

 

When I use this categories for the x-axis i get something like that:

 

 1.PNG

 

Two difficulties:

- Sorting because the categories are in type text 

- It is not compact and i have to scroll because there are to many categories

 

The sorting problem i could maybe solve by creating a new column with numbers and assign to the categories. But how can i represent the categories without scrolling at the end? I dont see a possibility to move the columns together. Maybe there are appropriate visuals to do things like that? 

 

Many thanks for ideas.

 

5 REPLIES 5
Pikachu-Power
Post Prodigy
Post Prodigy

Hi @v-cgao-msft 

many thanks for your response. I was thinking about python. Are there some suitable / helpful sides with python codes for histograms? Otherwise i will search.

Hi @Pikachu-Power ,

Here:
Create Power BI visuals using Python in Power BI Desktop - Power BI | Microsoft Learn
Using Python Visuals in Power BI - AbsentData
Histograms — Matplotlib 3.8.2 documentation

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

I have 222,000 rows in my dataset. Does the limitation of 150,000 rows are also valid for histogram?? 

 

When i try bar plot my calculation exceeds five minutes and run into time out. But for histogram it seems to work and i get no message. So i dont know if there is a mistake in my results.

v-cgao-msft
Community Support
Community Support

Hi @Pikachu-Power ,

I've done some testing and can't seem to get rid of the column chart gaps.

Consider use some custom visuals:
Business Apps – Microsoft AppSource
Templates | Deneb (deneb-viz.github.io)
Example Gallery | Vega-Lite
Histogram Example | Vega

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

saudansari
Helper II
Helper II

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.