Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello all,
I'm having an issue that confuses me to the most: the count of values in my visual, for the current month, is not matching the number of rows in my dataset.
In my data, I have the following:
492 rows available. 'Is Categorized by L2?" column contains no empty row.
Yet, my visual only counts 434 values
If I change the filter and display previous months, results are correct. But for March, 58 values are "ignored" by the visual.
I have no additional filter on the visual/page/pages
I'm sure it's something silly but what am I missing here?
Thank you,
Doris
Solved! Go to Solution.
It's a bit tricky to diagnose just from that information but
1. Sort out the datatypes in Power Query - Some of them are set to 'any' type when they should be text
2. Check the column Quality stats (under the View menu->tickboxes)
3. Check the rowcount from Data View in powerbi. Select the column and you'll get summary stats at the bottom of the page
4. Hover over the funnel icon on the card visual - this will identify the filters directly affecting it.
It's a bit tricky to diagnose just from that information but
1. Sort out the datatypes in Power Query - Some of them are set to 'any' type when they should be text
2. Check the column Quality stats (under the View menu->tickboxes)
3. Check the rowcount from Data View in powerbi. Select the column and you'll get summary stats at the bottom of the page
4. Hover over the funnel icon on the card visual - this will identify the filters directly affecting it.
Thank you for your answer.
In fact, the issue was as silly as I imagined. I have a timeline visual downloaded from Power BI store, that was filtered on March before I refreshed my dataset. Apparently, this filter doesn't take into account new data. Removing March filter and reapplying it was enough to fix the issue.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |