Forum Discussion
Altering Line chart display
- 6 years ago
Hi VinayakKarne ,
I have created dummy data, below are my numbers from initial table
Initial Table
Below is the snapshot of data post Unpivot on Month Name Columns, Post Unpivot i have renamed Attribute column to Month.
Table post Unpivot
Created a measure as suggested earlier.
Measure for calculation
create a table with Month names and Index to sort your graph by Month for sorting purpose, create relationship between newely created table with data table on Month
January 1 February 2 March 3 April 4 May 5 June 6 July 7 August 8 September 9 October 10 November 11 December 12 below is the line chart with no selection on Type slicer
Visual with No Type Selection
Visual with Giver Selection
screenshot with Reciever selection on slicer.Visual with Reciever Selection
I hope this will help you in resolving your issue.
Thank You,
Washivale
Hi Washivale,
I have alredy added the sample data in my query.
Thanks for reply
Washivale wrote:Hi VinayakKarne
is it possible for you to attach sample records/file to use in power bi desktop
Regards,
Washivale
Hi VinayakKarne ,
I have created dummy data, below are my numbers from initial table
Initial Table
Below is the snapshot of data post Unpivot on Month Name Columns, Post Unpivot i have renamed Attribute column to Month.
Table post Unpivot
Created a measure as suggested earlier.
Measure for calculation
create a table with Month names and Index to sort your graph by Month for sorting purpose, create relationship between newely created table with data table on Month
| January | 1 |
| February | 2 |
| March | 3 |
| April | 4 |
| May | 5 |
| June | 6 |
| July | 7 |
| August | 8 |
| September | 9 |
| October | 10 |
| November | 11 |
| December | 12 |
below is the line chart with no selection on Type slicer
Visual with No Type Selection
Visual with Giver Selection
screenshot with Reciever selection on slicer.Visual with Reciever Selection
I hope this will help you in resolving your issue.
Thank You,
Washivale