Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have data as below..
ATTEMPT DATE | No |
20-Jul-17 | 1 |
23-Jul-17 | 1 |
2-Aug-18 | 1 |
3-Aug-18 | 1 |
18-Aug-17 | 1 |
2-Sep-17 | 1 |
29-Jul-18 | 1 |
28-Aug-17 | 1 |
1-Aug-17 | 1 |
31-Aug-17 | 1 |
When tried to plot a bar chart all the months are clubbed together, as below..
Am looking for variation in Year + Months combo. like below..
Simple but am struck in exploring. Please help and also I need the X-Axis in Year+Month sorting. Normally its been arranged as Characeter
Solved! Go to Solution.
Hi @sunilege,
Could you please check if you have checked the 'Show dates as a hierarchy' option in your Power BI Desktop?
Regards,
Daniel He
Hi @sunilege,
Based on my test, you could choose the Year and Month filed in the date hierarchy:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi @sunilege,
Could you please check if you have checked the 'Show dates as a hierarchy' option in your Power BI Desktop?
Regards,
Daniel He
Hey got it. It affected now.
Thankyou!!
@v-danhe-msft You can see my 3rd post what I was explaining in the eariler one.
Yes, This I have enabled but still there no improvement.
In your pbix file the graph name itself is "Count of No by Year and Month". Can you remove/uncheck the Month or/and year field and re-include it/them and try.
When we re-incude it/them this is losing the functionality.
Only options avialable now are..
1. "Count of No by Year "
2. "Count of No by Month"
But not "Count of No by Year and Month" .
Hi,
The thing am not able find the hirearchy in field pane . Please see below..
Step 1: The same pbix file
Step 2: Unchecked the date field from field pane
Step 3: Checked the date field. No hirerachy seen in field pane but Iam able to hirerachy in vizualiation pane I have removed Qtr and Day and retained Year and Month but that is not helping see below..
Hi Daniel,
Thankyou!!
When I tried to edit the hirerarchy and again choosed year month it not arriving again as desired. Why this could be ?