Forum Discussion

VinayakKarne's avatar
VinayakKarne
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's avatar
    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

     

    January1
    February2
    March3
    April4
    May5
    June6
    July7
    August8
    September9
    October10
    November11
    December12

     

    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

Washivale's avatar
Washivale
Resolver V
6 years ago

Hi VinayakKarne ,

 

To get both gridline you should turn on gridlines option under X axis and Y axis as well

 

for getting value of based on your selection create a measure as below (considering your value summation value would be in one column, for easier calculation):

 

Measure =
var rec = CALCULATE(SUM('Table'[Column1]), 'Table'[Type] = "Reciever")
var giv = CALCULATE(SUM('Table'[Column1]), 'Table'[Type] = "Giver")
return
If(SELECTEDVALUE('Table'[Type])="Giver",giv, IF(SELECTEDVALUE('Table'[Type])="Reciever", rec, rec-giv))
 
let me know if it helps.
 
Thank You,
Washivale

 

  • VinayakKarne's avatar
    VinayakKarne
    Frequent Visitor
    6 years ago

    Hi Washivale, There is no option under x axis for grid lines. 

    Also since there are 12 months so how couldi differentiate them while summation in one measure based on above method.

     

    It would be easier for me if you could show me some examples.

     

    Thanks for reply.

    Washivale wrote:

    Hi VinayakKarne ,

     

    To get both gridline you should turn on gridlines option under X axis and Y axis as well

     

    for getting value of based on your selection create a measure as below (considering your value summation value would be in one column, for easier calculation):

     

    Measure =
    var rec = CALCULATE(SUM('Table'[Column1]), 'Table'[Type] = "Reciever")
    var giv = CALCULATE(SUM('Table'[Column1]), 'Table'[Type] = "Giver")
    return
    If(SELECTEDVALUE('Table'[Type])="Giver",giv, IF(SELECTEDVALUE('Table'[Type])="Reciever", rec, rec-giv))
     
    let me know if it helps.
     
    Thank You,
    Washivale

     

     

    • Washivale's avatar
      Washivale
      Resolver V
      6 years ago

      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

      • VinayakKarne's avatar
        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