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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Need Help - Create visual showing row count measures from various tables

I am currently creating a dashboard that will show the row counts of various  ables per period. I have created a row_count measure for each table that can be altered uisng a slicer.  I trying to display the counts for each table in a chart where the y axis is the row count number and the x axis lists the different tables. However I end up with the following:

 

sauce1979_0-1723712763863.png

Am I using the wrong  visual? I was thinking of creating a separate measure table with all the row counts from the different tables. That didnt seem to work. any advice would be much appreciated. I am fairly new to Power BI so I understand that this is a bit of a beginner question.

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

HI @Anonymous 
If I understood you correctly, please select a clustered graph instead of a stacked one.

Ritaf1983_0-1723713550930.png

If not 

 please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

I managed to get something close to wht i needed by switching to a clustered chart. Just need to format it further.

 

thank you @Ritaf1983  for the initial suggestion

sauce1979_0-1723793816944.png

 

Anonymous
Not applicable

@Ritaf1983 Apologies I didnt realize I had restriced the access to the pbix. The link can be accessed now

Ritaf1983
Super User
Super User

HI @Anonymous 
If I understood you correctly, please select a clustered graph instead of a stacked one.

Ritaf1983_0-1723713550930.png

If not 

 please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Anonymous
Not applicable

@Ritaf1983   have created a pbix with some sample data  https://drive.google.com/file/d/1HHYx66LmByX3Z1ZBIV1-kHJ52j9Zh5bf/view?usp=drive_link

 

thanks in advance

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.