Forum Discussion

daledale's avatar
daledale
Frequent Visitor
6 years ago
Solved

Line Chart - 2 budgets 1 Node

Hi everyone,   I'm trying to create a line chart that change with according 2 slicers. One slicers contains Nodes (1,2,3,4, etc...). The other one contains Budgets (A, B, C, etc...) The line c...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi daledale,

     

    check this out.

     

    CATEGORY_NODE = 'Table'[Nodo] & ", " & 'Table'[SDO]

     

     

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

amitchandak's avatar
amitchandak
Super User
6 years ago

Not sure I got it completely. But if you put the budget in legend, then it should show two line. 

  • daledale's avatar
    daledale
    Frequent Visitor
    6 years ago

    Sorry for my late reply, I'm really stucked with this PBI and need to solve many issues I cannot find solutions for..

    This is the way I have my tables (it's actually an unpivotted table)
    NODE - CATEGORY - COUNTRY - ATTRIBUTE - VALUE
    1                 A                   XX               Q1               $$

    1                 B                   XX                Q1                $$
    2                  A                 XXXX             Q1                $$
    2                  B                 XXXX             Q1                $$

    And so on... 
    I have 2 slicers, which I use to filter my line charts.
    1 is for NODEs, one is for CATEGORY.
    If I filter by Category, I'm ok. Because I see a line for Category A, belonging to NODEs 1, 2, etc...
    But if I filter by NODE, it shows me A+B as only one line in the chart.

    Right now I have the NODEs in my legend and Attributes in my Axis.

     

     

    • mwegener's avatar
      mwegener
      Most Valuable Professional
      6 years ago

      Hi daledale ,

       

      maybe you could create a calculated column (Category & Node) and use it in the legend.

       

      CATEGORY_NODE = CONCATENATE('Table'[CATEGORY],'Table'[NODE])
       
      If I answered your question, please mark my post as solution, this will also help others.
      Please give Kudos for support.
      • daledale's avatar
        daledale
        Frequent Visitor
        6 years ago

        Thanks again, but what I need is to show them as 2 different lines when I filter by Node.
        Meaning, I want to filter Node 1, and see a line for Category A, and a line for Category B.