Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
I have a table with date dimension starting from 2012, here is an example:
| Serialnumber | Avalue | Bvalue | Date |
| 123456 | 1 | 0 | 01.01.2012 |
| 123457 | 1 | 0 | 02.01.2013 |
| 123458 | 1 | 0 | 03.01.2021 |
| 123459 | 0 | 1 | 04.01.2021 |
| 123460 | 0 | 1 | 04.01.2021 |
| 123461 | 1 | 0 | 06.01.2021 |
| 123462 | 0 | 1 | 06.01.2021 |
| 123463 | 0 | 1 | 08.01.2021 |
In the bar chart I count the serialnumber with specific condition base on the flags in the second and third column.
My problem is....why the barchart is only showing me the count of all quarters, all month, 31 days of a month cummulated?
but not all dates available?
When I set dimension to date it should show me the count of these days back to 2012, for each day. Instead it shows me only the count of serialnumbers of a range of 31 days, apparently based on which same weekday it was, accumulated of all those years:
What happens if you turn on the switch for "Concatenate Labels"
You can find this setting in format options of the visual and then x-axis
Hello @Anonymous,
thank you very much so far. I'm one step further, when I switch from "category" to "concatenate labels". I don't know if I'm to used to Qlik or so, but is there nothing like a autocalendar in powerbi. I means like below the bar chart, where I can switch between different dimensions, e.g. dates, week year?
After concatenate is on its going to the whole range of dimension, but only something outside of the bar chart, like a slicer filter can zoom in specific date ranges.
Is that how power bi works?
Thx.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 74 | |
| 50 | |
| 47 | |
| 44 |