Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Dear community
"I Want to slice dealer achivemnt sales with percentage slicer in scale of 0 to 100 % ".
I have data as like this image
I have a table name of Cube_ invoice in which
Sold to partner code is dealer code and name is dealer name column
invoice quantity cloumn
target quantity cloumn
i calculate tagrget achived% of dealer with this measure
Target Achieved % = DIVIDE( SUM(CUBE_INVOICE[INVOICE QUANTITY]), SUM(CUBE_TARGET[TARGET QUANTITY]) )
Now i want to create a slicer of percentge in scale of 0 to 100 % , which satisfying this condition if i select 0 to 20 % in slicer it should only return of those dealer name and their sales which has acheived thieir 20% sales not return all the value.
Please help
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thank you sir for your suggestion
User | Count |
---|---|
71 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
24 |