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 All
(1) Procedure to create a dynamic dimension table.
Step 1 Create a SliceTable with value label = Brand . Segment for user selection purpose.
Step 2 Create a measure for display Dimension value label.
Step 3 Create a measure for display the sales amount.
Step 4 create a Summarize table with rank field for Brand.
Step 5 Create a Summarise table with rank field for Segment.
Step 6 link the Step 4 and 5 table by Rank.
(2) Working PBI file create by @v-yangliu-msft :-
https://www.dropbox.com/s/f1hdxxe486o803s/WORKING.pbix?dl=0
I have create a totally new PBI file from import raw data and follow the above step by step , and i still unable to get it work. My issue is i can set when user select Brand . Table 1 can display sales by Brand , But when user select Segment , it cannot display display sales by segment correctly as every row same value.
(3) Not working PBI file create by me :-
https://www.dropbox.com/s/g75b3te1tldthvv/NOT%20WORKING.pbix?dl=0
Paul Yeo
Hope some one can share with me why PBI file create by me not able to work ?
Thank
Paul
Hi All
@v-yangliu-msft have share with me below post on step by step for create dynamic dimension :-
In order to undertand , i have create a new PBI file follow above every step by step.
(1) When Slice= BRAND , Table can display Brand info is correct :-
(2) My issue is when i select Sliec = SEG_SUB , Table 1 2nd column not display data.
Hope some one can share with me where go wrong ?
My PBI sample file :-
https://www.dropbox.com/s/hulunsd3zjn67qg/SAMPLE_1000_SI_TI_V012.pbix?dl=0
Paul Yeo
Hi, @admin11
Measure 'S_amount_TOTAL' is not complete. The description of value “SEG_SUB” is misssing in function 'Switch'.
Please modified it as below:
Result:
Best Regards,
Community Support Team _ Eason
Thank you very much for your help.
I have check the attach file , i notice that s_amount_TOTAL2 you already have the below full expression , But the Table 1 still not giving correct result when i click on SEG_SUB button ?
Hope you can resend the working PBI file . so that i can see that table can display amount when i select brand and seg_sub
Paul
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |