cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shreyash1729
Regular Visitor

How to change the target values according to filters

Hi Team,

I have created a matrix from table, in which there are some KPIs, monthly values and target values. Is there any way that my target value will change according to filter options ?

 

Thanks

9 REPLIES 9
RobbeVL90
Regular Visitor

Re: How to change the target values according to filters

Hi,

Ofcourse it should! That is the main strenght of Power BI.
I'm guessing your relationships are not defined, or no relationship is possible.

 

I'm happy to help further if you share a Pbi desktopfile  or add some more info.

 

Robbe

shreyash1729
Regular Visitor

Re: How to change the target values according to filters

Hi Robbe,

Thanks for your response.

I have created the relationship but problem here is that my target are different at different levels so is it possible that same will apply as per slicer selection.

 

 

 

Highlighted
Super User I
Super User I

Re: How to change the target values according to filters

You might wanna work with a SWITCH function. 
Once again, please provide some sample data if you want more help.

 

Robbe

Community Support
Community Support

Re: How to change the target values according to filters

hi, @shreyash1729 

You may refer to this similar post:

Dynamically change the information within a visual via a slicer

 

If not your case, please share your simple sample pbix file and expected output.

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
shreyash1729
Regular Visitor

Re: How to change the target values according to filters

Hi,

Thanks for the support. Can we meet on skype or webex so that I can show the requirement.

 

I am available between 11:00 to 19:30 IST (GMT +5:30). Let me know your suitable time.

 

Thanks

Community Support
Community Support

Re: How to change the target values according to filters

hi, @shreyash1729 

If you want Microsoft support team help you, please create a SUPPORT TICKET in here.

Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Once you submit the ticket, you will get an email from support@mail.support.microsoft.com. Someone from the  Microsoft support team will contact you.

 

and you could also post the sample data and your expected output as below:

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
shreyash1729
Regular Visitor

Re: How to change the target values according to filters

Spoiler

@v-lili6-msft & @RobbeVL 

Please find attached the sample Power BI with reference raw data. Here we have different market (in slicer) with different target values. I need to make conditional formatting for KPI values based on different market target figures. If I select any market from slicer then it should show respective market target and KPI value with colour formatting. I am facing challenge to put conditional formatting based on different target.

 

Thanks in advance for your support.

 

 

shreyash1729
Regular Visitor

Re: How to change the target values according to filters

Hi, @v-lili6-msft  @RobbeVL  

 

Any suggestion as per shared Power BI in my last message.

 

Thanks

Community Support
Community Support

Re: How to change the target values according to filters

hi, @shreyash1729 

What is your expected output(put conditional formatting based on different target)?

Could you show the expected with this sample?

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors