How to change the target values according to filters

[shreyash1729]

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

[Anonymous]

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]

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.

[v-lili6-msft]

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

[shreyash1729]

Spoiler

Pbix:-                    https://drive.google.com/open?id=18Jlbkahq1OB1tn4mS0GnskPgv44yz7jc
Support excel:-    https://drive.google.com/open?id=14f5uCgnugo4TjgnHfDbJhEXOlOc17c8P

@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]

Hi, @v-lili6-msft  @RobbeVL  

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

Thanks

[v-lili6-msft]

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

[shreyash1729]

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

[v-lili6-msft]

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

[RobbeVL]

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

Robbe