I need help graphing my fields parameters

[Kin_cta]

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, it doesn't display anything. It shows the data as text, and when I try to change it to decimal, it says it can't be changed. I watched many videos where they did the same thing, but I can't get it to work. Please, I need help with this.

[dk_dk]

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]

Done. Now what?

[dk_dk · Accepted solution]

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]

Thank you so much, you're the best! 🤗

[GeraldGEmerick]

@Kin_cta Any chance you can share your file?

[Kin_cta]

No.	MUNICIPIO	RMC_AGUA	RMC_MATERIALES	RMC_ENERGIA	RMC_SUELO
1	Agua de Dios	0,359953704	0,39205	0,3382	0,510526316
2	Anapoima	0,436921296	0,5028	0,58415	0,510526316
3	Anolaima	0,145833333	0,3884	0,58485	0
4	Apulo	0,291087963	0,5028	0,5054	0,173684211
5	Bojacá	0,58275463	0,2869	0,4218	0,168421053
6	Cachipay	0,436921296	0,29615	0,5054	0,826315789
7	Cajicá	0,434606481	0,80535	0,1779	0,657894737
8	Chía	0,508101852	0,58945	0,58135	0,5
9	Chocontá	0,436921296	0,29615	0,4218	0,489473684
10	Cogua	0,434027778	0,5738	0,1779	0,663157895
11	Cota	0,220486111	0,3708	0,50605	0,342105263
12	Cucunubá	0,43287037	0,6172	0,50125	0,331578947
13	El Colegio	0,145833333	0,3884	0,3275	0,831578947
14	El Rosal	0,508101852	0,37915	0,3382	0,489473684
15	Facatativá	0,220486111	0,37915	0,2615	1
16	Funza	0,581597222	0,6826	0,6629	0,663157895
17	Gachancipá	0,362268519	0,37915	0,5793	0,173684211
18	Girardot	0,070601852	0,27855	0,25805	0,326315789
19	Granada	0,295138889	0,29615	0,4218	0,342105263
20	Guatavita	0,289351852	0,48065	0,8287	0,173684211
21	La Calera	0,4375	0,5886	0,6643	0,5
22	La Mesa	0,511574074	0,37915	0,5054	0,831578947
23	Madrid	0,508101852	0,4723	0,6615	0,657894737
24	Mosquera	0,436921296	0,57745	0,4218	0,331578947
25	Nemocón	0,58275463	0,29615	0,5793	0,326315789
26	Quipile	0,216435185	0,488	0,4218	0,489473684
27	Ricaurte	0,50462963	0,27765	0,4204	0,342105263
28	San Antonio del Tequendama	0,216435185	0,29615	0,5054	0,173684211
29	Sesquilé	0,508101852	0,4723	0,6629	0,657894737
30	Sibaté	0,440972222	0,3893	0,42385	0
31	Soacha	0,362268519	0,6826	0,5862	0,668421053
32	Sopó	0,723958333	0,19465	0,58275	0,5
33	Subachoque	0,219907407	0,48065	0,25805	0,668421053
34	Suesca	0,362268519	0,49355	0,3382	0,5
35	Tabio	0,436921296	0,7002	0,25805	0,5
36	Tausa	0,216435185	0,29615	0,58485	0,342105263
37	Tena	0,145833333	0,1015	0,5054	0,505263158
38	Tenjo	0,28587963	0,57745	0,34165	0,173684211
39	Tocaima	0,365740741	0,37915	0,7465	0,331578947
40	Tocancipá	0,289351852	0,27765	0,1603	0,510526316
41	Villapinzón	0,362268519	0,29615	0,5054	0,168421053
42	Viotá	0,291666667	0,48065	0,5054	0
43	Zipacón	0,220486111	0,203	0,5054	0,489473684
44	Zipaquirá	0,43287037	0,4723	0,6615	0