Forum Discussion
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, 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.
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.
6 Replies
Kin_cta Any chance you can share your file?
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
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 questionsDone. Now what?
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.
