Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear All,
I am infant to Power BI and I am implemenitng line Chart using data in excel,
In the line chart It is showing the lines of year in below format
But my client request to see his line chart in below format
Can any one please help in solving this issue by going through the below Power BI file
https://www.mediafire.com/folder/jn1hiwrqhm6gt/
Solved! Go to Solution.
Create a new Calculated Column as and use it in Line Axis. You can sort visual asc/desc based on this column.
YYYY/QQ = COMBINEVALUES("/",Table2[Year],Table2[Quarter])
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
Create a new Calculated Column as and use it in Line Axis. You can sort visual asc/desc based on this column.
YYYY/QQ = COMBINEVALUES("/",Table2[Year],Table2[Quarter])
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
Tq for your response,
After using the below formula in new column I am getting tis result
Hello Ankit,
Tq for your kind information, I retroed and really I don't need legend.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |