Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
WaleedBinAli
Frequent Visitor

Need help with Graphical Visualization

Hi there,
Thanks in advance.
I want to create a graph in which on x axis there should 2 values one which will always exist when nothing will be clicked in table such as PROFIT AFTER TAX and other value should be displayed on that graph when some field is clicked on table.

Suppose, country name should be displayed on x label and on y axis actual, budget and projection these values are given. Value of Profit after tax should always be visible when nothing is clicked in table when some field or value is clicked that should be displayed instead of profit after tax and when unchoose the field or value from the table then it display profit after tax in that graph. I am using Clustered Column Chart.
Q1.PNGQ2.PNG

3 REPLIES 3
WaleedBinAli
Frequent Visitor

Any solutions??

amitchandak
Super User
Super User

@WaleedBinAli , I would advise exploring field parameters in Power BI. Bit different but can solve the purpose 

 

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you @amitchandak 
Just let me know can we specifically assign a slicer only to graph. Where it change only the values in graph not on whole page.
And the field parameters are good will use when i will update my Bi. 

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.