Forum Discussion
Dynamic Calculation based on selected slicers
Hi Team
I need a small kind of requirement I have using a estimate type column as a slicer its having multiple fields based on the selection of multiple filds we need to do the calculation like below screenshot and result should be shown in a matrix table same as like below example. how can we do this with the help of dax please help me on this. Thank you so much in advance.
Hi Anonymous ,
You can create two unconnected tables for two slicers.Model.
Output:
Please check the attachment.Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
3 Replies
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi Anonymous ,
You can create two unconnected tables for two slicers.Model.
Output:
Please check the attachment.Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Thank you so much it was working as expected I need to include one more point here please suggest me how to do that base on the comparision of the 2 slicers the results should in conditional formatting applied. below is the scenario
=> If the resulted value is more 5% sales than slicer1 selected sale value then resulted sale value background colour should be red in colour.
=> If the resulted value is less 5% sales than slicer1 selected sale value then resulted sale value background colour should be green in colour.Else
Yellow in colour
Could you please help me in this scenarion. I reaaly appreciate your help.
Thank you so much in advance.
