Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |