Forum Discussion

Frequent Visitor

6 years ago

Solved

Altering Line chart display

Hi Team, I am currently trying to display the table data based on the summation of amount of months based on year and type. The data is need to be displayed on Line chart. The chart is updated ba...

Need Help

Show and Tell

Tips and Tricks

Washivale
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

VinayakKarne

Frequent Visitor

6 years ago

Hi Washivale,

Thanks for reply. Yes we can bring the data in single column but the problem is how we are going to make final table column data based on above measure i.e for individual month and displaying in the line chart. It would be more easy for me to understand if you could show me a sample of 2 or 3 entries.

Thanks

Washivale wrote:
Hi VinayakKarne ,

Ahhh sorry, Vertical gridlines are not supported for text axis, it is supported for numerical axis only.

for getting your values in one column, you should unpivot your data using Unpivot option under edit query - transform section.
select all months and click unpivot option.

Regards,
Washivale

Washivale

Resolver V

6 years ago

Hi VinayakKarne

is it possible for you to attach sample records/file to use in power bi desktop

Regards,

Washivale

VinayakKarne
Frequent Visitor
6 years ago
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
- Washivale
  Resolver V
  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

Forum Discussion

Altering Line chart display

Related content

SQL ALTER command

Line Chart Visual Axis Value Display

Display Chart with Normalized Values

Alter DAX measure to display highest value in a line chart

Using Field Parameters to Alter My Table Visual Content

January	1
February	2
March	3
April	4
May	5
June	6
July	7
August	8
September	9
October	10
November	11
December	12