Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
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.
Solved! Go to Solution.
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
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
@Ritaf1983 Apologies I didnt realize I had restriced the access to the pbix. The link can be accessed now
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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 48 | |
| 44 | |
| 42 | |
| 18 | |
| 18 |
| User | Count |
|---|---|
| 72 | |
| 68 | |
| 33 | |
| 33 | |
| 31 |