Forum Discussion
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:
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.
HI Anonymous
If I understood you correctly, please select a clustered graph instead of a stacked one.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
4 Replies
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
HI Anonymous
If I understood you correctly, please select a clustered graph instead of a stacked one.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
Ritaf1983 have created a pbix with some sample data https://drive.google.com/file/d/1HHYx66LmByX3Z1ZBIV1-kHJ52j9Zh5bf/view?usp=drive_link
thanks in advance
Ritaf1983 Apologies I didnt realize I had restriced the access to the pbix. The link can be accessed now