Generar grafico con parametros de campo

[mchercol]

Hola buenos dias.

Me surge un  problematica que no se muy bien si se puede resolver.

Tengo creados los siguientes parametros de campo:

Donde se comparan en una misma grafica valores .

Podia crear una gráfica donde este compuesta por los parametros de campo que tengo ya creados y que se pueda mostrar una mediante el slicer creado con esos parametros de campo un grafico u otro en funcion del slicer seleccionado?

Gracias por adelantado

[v-mengmli-msft · Accepted solution]

Hi @mchercol ,

Thanks for @dk_dk reply, it is a great way!

@mchercol According to your description, do you want to display data from two tables using one visual? As far as I know, PowerBI does not support dynamically changing fields in visual. I suggest that you can merge the two tables into one table, like this.

CustomTable  = UNION(SELECTCOLUMNS(Table1,"NewColumnName1",Table1[Column1],"NewColumnName2",Table1[Column2]),SELECTCOLUMNS(Table2,"NewColumnName1",Table2[Column3],"NewColumnName2",Table2[Column4]))

The results in my test.

Best regards,

Mengmeng Li

[dk_dk]

Hi @mchercol 

Sorry I am answering in English because my Spanish is no bueno. Hope you understand or the translation is clear enough.

I think it is easier to achieve what you want with buttons and bookmarks.

You can set up your page so your two charts are overlapping eachother.

You can go to View > Selection  and hide one of the charts. Then go to View > Bookmarks and set a bookmark.
Then hide the visible chart and unhide the hidden one, and set another bookmark.

Then you can add two buttons ("view Peso_Ton chart" and "View Solicitudes chart") and set the action to Bookmark. Clicking the the buttons would toggle which of the two charts are visible. You might want to configure that the relevant slicers also appear/disappear together with the chart.

I hope this helps. You can read more about bookmarks in Spanish here:  https://learn.microsoft.com/es-es/power-bi/create-reports/desktop-bookmarks?tabs=powerbi-desktop

[mchercol]

Habia pensado en esa solucion, pero querri hacer con parametro, ya que me parece que queda mas limpio

Gracias