This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
It is possible to create above visual where we have distribtion as per month and year
Solved! Go to Solution.
@jkhan , With year and month on axis. you should have that. Expand till month level. If needed use concatenate label in format.
Make sure Month sort on month no
Month = FORMAT([Date],"MMM")
Month No = FORMAT([Date],"MM") //month sorted on this column
@jkhan , With year and month on axis. you should have that. Expand till month level. If needed use concatenate label in format.
Make sure Month sort on month no
Month = FORMAT([Date],"MMM")
Month No = FORMAT([Date],"MM") //month sorted on this column
Hi Amit,
Thank you very much for your assistance. I figure it out. Now i can see desire output.
Thanks Again.
HI Amit,
can you please explain what do you mean by "Expand till month level"
Best Regards
Jamsher
Hi Amit I tried your steps but its showing only year for me
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 14 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 47 | |
| 39 | |
| 24 | |
| 20 | |
| 20 |