Forum Discussion

Kin_cta's avatar
Kin_cta
Regular Visitor
6 months ago
Solved

I need help graphing my fields parameters

I want to create a dynamic chart, and I found the option to do it using field parameters. I selected the corresponding columns, which contain decimal data, but when I try to create the chart, i...
Need Help
Show and Tell
Tips and Tricks
  • dk_dk's avatar
    dk_dk
    6 months ago

    The Field parameter should be referencing the measures, not the column, like so:

    RMC = {
        ("RMC_AGUA", NAMEOF('water'[m_RMC_AGUA]), 0),
        ("RMC_ENERGIA", NAMEOF('water'[m_RMC_ENERGIA]), 1),
        ("RMC_MATERIALES", NAMEOF('water'[m_RMC_MATERIALES]), 2),
        ("RMC_SUELO", NAMEOF('water'[m_RMC_SUELO]), 3)
    }



    And you should put the measures on the original table (i called mine water as an example)
    When you click on the measure you should be able to change the home table in the top left corner.

     




dk_dk's avatar
dk_dk
Super User
6 months ago

Hi Kin_cta 

You need to create measures for each of your columns like this:

m_RMC_AGUA = SUM(Table[RMC_AGUA])

and use these measures in the field parameter.

On just the columns power bi does not know how to aggregate them when they come through the parameter.



Hope this helps! let me know if you have any questions




  • Kin_cta's avatar
    Kin_cta
    Regular Visitor
    6 months ago

    Done. Now what?

    • dk_dk's avatar
      dk_dk
      Super User
      6 months ago

      The Field parameter should be referencing the measures, not the column, like so:

      RMC = {
          ("RMC_AGUA", NAMEOF('water'[m_RMC_AGUA]), 0),
          ("RMC_ENERGIA", NAMEOF('water'[m_RMC_ENERGIA]), 1),
          ("RMC_MATERIALES", NAMEOF('water'[m_RMC_MATERIALES]), 2),
          ("RMC_SUELO", NAMEOF('water'[m_RMC_SUELO]), 3)
      }



      And you should put the measures on the original table (i called mine water as an example)
      When you click on the measure you should be able to change the home table in the top left corner.

       




      • Kin_cta's avatar
        Kin_cta
        Regular Visitor
        6 months ago

        Thank you so much, you're the best! ðŸ¤—