cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kkalyanrr Member
Member

Changing the fields on the Charts through Slicer connected to the Chart (Dynamic Fields)

Hello Team,

 

Is there any DAX query to change the field in the Chart Visual.

 

For eg.. I've a table with Columns A1,A2,A3,A4.,A5..  where in I need to calculate the sum of Column A5 and should be able to drill it through A1,A2,A3,A4,A5. So I was planing to have only one chart and a slicer so that I can change the chart o/p based on slicer selection A1/A2/A3/A4.

 

Thanks,

Kalyan.. 

5 REPLIES 5
kkalyanrr Member
Member

Changing the fields on the Charts through Slicer connected to the Chart (Dynamic Fields)

Hello Team,

 

Is there any DAX query to change the field in the Chart Visual.

 

For eg.. I've a table with Columns A1,A2,A3,A4.,A5..  where in I need to calculate the sum of Column A5 and should be able to drill it through A1,A2,A3,A4,A5. So I was planing to have only one chart and a slicer so that I can change the chart o/p based on slicer selection A1/A2/A3/A4.

 

Thanks,

Kalyan.. 

Super User
Super User

Re: Changing the fields on the Charts through Slicer connected to the Chart (Dynamic Fields)

Hey,

 

I'm not sure if I understand you correctly, but maybe this is similar

https://community.powerbi.com/t5/Desktop/Calculate-Month-over-Month-with-Month-filter/m-p/216879#M96...

 

also look here

http://www.leanx.eu/tutorials/dynamic-dimensions-in-power-bi

 

Hopefully this gets you started.

 

Regards

Tom

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
kkalyanrr Member
Member

Re: Changing the fields on the Charts through Slicer connected to the Chart (Dynamic Fields)

Hello Tom,

 

The second URL is helpful, but the only problem is creating artificial join table manually (in the given example its just 3 dimensions and 230 records)..but in case of large data sets , is there a way we can link artificial join table directly with main table?

 

Thanks,

Kalyan..

v-ljerr-msft Super Contributor
Super Contributor

Re: Changing the fields on the Charts through Slicer connected to the Chart (Dynamic Fields)

Hi @kkalyanrr,

 

If I understand you correctly, I don't think there is an easy way to do it in Power BI currently. You may need to merge the values in A1,A2,A3,A4 into a single column with the corresponding column name in another column to make it work.  Smiley Happy

 

Regards

Super User
Super User

Re: Changing the fields on the Charts through Slicer connected to the Chart (Dynamic Fields)

Hey,

 

still not able to fully understand your requirement, but this pattern relies heavily on the "concept" of unrelated tables. Unrelated table does not mean, you have to create the table manually, you also can use to automate the creation of this table using Power Query or create a view inside your data source if you are on direct query.

 

From a performance perspective, maybe you get yourself familiar with the following DAX functions

 

Hope this helps

 

Regards

Tom

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 130 members 1,703 guests
Please welcome our newest community members: