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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
sauce1979
Frequent Visitor

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 @sauce1979 
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
sauce1979
Frequent Visitor

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

 

sauce1979
Frequent Visitor

@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 @sauce1979 
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

@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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.