Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I want to display my data as group using slicer in power bi. I have stage column in my table. I want to segregate my stage as 2 categories(open and close) with the stage data values.
Example: The following data values grouped into open or close respectively.
Open = Alternative, Budget price, Negotiation/Review, Order Agreed, Prospecting/Design Assist, RFQ (means request for quotation), Tender Proposal, On Hold
Closed = Alternative Declined, Cancelled, Lost, No Bid, Order Received (Won)
I need to use two slicers like stage open and stage close in my requirement with helpe of stage data(field). Stage open slicer should be having like Alternative,RFQ,etc similarly closed stage slicer should be have no bid,etc.
Example: I need to split my slicer as two category like open and close. I want to display all open stage values under open slicer and close values under close slicer.
Is it anyother way to split or grouping my slicer data in power bi? Could you please guide me how to do grouping my data with respect to slicers.
Thanks in advance.
Regards
Sridevi
Solved! Go to Solution.
Hi @sridevi
Create a Link Table with the column names OpportunityStage , GroupName
Eg.
Alternative, Open
Alternative Declined, Closed
Cancelled,Opened
BudgetPrice,Open
.....
.....
Create realtionship between the OpportunityFactTable and the LinkTable on OpportunityStage
Create slicer with Group Name
It should show then some thing like
Create a slicer for the opportunity stage
When you select Open in the GroupName Slicer only those grouped under Open will be shown in the Status Slicer
And similarly for Closed in the GroupName
If you have a table for reporting the Opportunity Fact Table it will vary depending the GroupName slicer selection.
Hope this solves your issue.
If it does please accept this as solution and also give KUDOS.
Cheers
CheenuSing
Hi @sridevi
Create a Link Table with the column names OpportunityStage , GroupName
Eg.
Alternative, Open
Alternative Declined, Closed
Cancelled,Opened
BudgetPrice,Open
.....
.....
Create realtionship between the OpportunityFactTable and the LinkTable on OpportunityStage
Create slicer with Group Name
It should show then some thing like
Create a slicer for the opportunity stage
When you select Open in the GroupName Slicer only those grouped under Open will be shown in the Status Slicer
And similarly for Closed in the GroupName
If you have a table for reporting the Opportunity Fact Table it will vary depending the GroupName slicer selection.
Hope this solves your issue.
If it does please accept this as solution and also give KUDOS.
Cheers
CheenuSing
Hi @CheenuSing,
Thank you for your suggestion. I can try to implement the same as per my requirement.
Regards
Sridevi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |