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.
Hi All - What is the best way to align the subsrciption counts from different years on the same line? See 1st picture.
Of course, I will eventually want to place the data in a graphic, and the same basic question applies ... what is the best way to align the yearly graphs to the left? See 2nd Picture.
Thanks for the help,
Mark
Hi All - What is the best way to align the subsrciption counts from different years on the same line? See 1st picture.
Of course, I will eventually want to place the data in a graphic, and the same basic question applies ... what is the best way to align the yearly graphs to the left? See 2nd Picture.
Thanks for the help,
Mark
Hey,
the simplest and only solution it this, just jemove the year column from the row headers.
As you use the column year 2 times
this will always be way the data is visualized inside the matrix visual, as the headers (row and column) are contributing to the filter context. As the data points do not exist for the the years 2017/2018 in parallel the data will be shown as a diagonal if the same columns are used on row and column headers.
Regards,
Tom
Hi All - any suggestions on this question?
I will be gald to add clarification if required.
Thanks,
Mark
It would be helpful to see a sample of your data, especially with how it's structured. Do you have different measures for your 2017, 2018, 2019 totals? What do your date fields look like?
Thanks,
Ben
we can do that
Hi All, @Anonymous
Here is a link to sample data: https://mega.nz/#!bzYhQACR!htR2NHK_xiK-XvnNkAjJ9zFw0HVbN1jq79jRYyK6mso
Since you already have subscription year in the columns, you do not need it in the rows.
Hi @tarunsingla -
Thanks for the comments.
Unfortunately, the ITD numbers are too high for 2017 and 2018. If you see the pics in the original post you will see that ITD numbers need to equal the inital month's numbers and increase from there.
The Year in the rows is not Subsription Year but rather the Calendar Date (Year) in which the subscription was logged into the system.
Mark
Hi All - any other suggestions out there?
Thanks, Mark
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |