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.

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.

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

    So?

    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

      mwegener sorry, I might not be expressing myself correctly. 

       

      Maybe with Screenshots it's easier:

      Node = Nodo
      Category = SDO
      My Node of Brasil has both sub categories. But when I filter only by Node, it adds up both:

      Filtering by Node and Category AFiltering by Node and Category BFiltering only by Node shows added up both

       

      I hope this claryfies my issue, Thanks again for the support!

      • mwegener's avatar
        mwegener
        Most Valuable Professional
        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.