Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
HI,
Kindly help me the below,
I am trying to create Matrix , i have two table Actual and customer
Actual is current year business done cases - in this Apple, Dell, HP, Lenovo OEM are there
Customer : Each region no customer in Count.
First column : Region
Second column : No Customer Available respactive Region,
Thired coulmn: Looking how many customer is done business in apple or Dell, etc.
I need first two column to be fixed and 3 column is based on the slicer need to be change example if i select Apple then first two column is stable 3 column will show how many customer we have done Apple Business. attached image below
Looking Result. If select Apple first two column fixed , 3rd column will get change based product .
Solved! Go to Solution.
Hi All,
Now its working fine..
I have tried the below Measure..
Hi All,
Now its working fine..
I have tried the below Measure..
Hi, @Sudhakar1000
Based on your information, I create sample tables:
Actual table
Customer table
Then create a new measure, try the following DAX expression:
SelectedProductCustomers =
CALCULATE(
COUNTROWS(Actual),
Actual[Product] = SELECTEDVALUE('Actual'[Product])
)
Create a Slicer view and put Product in it, create a matrix visual, put Region and No Customer Available fields in it. Here is my preview:
When using the slicer, only the third column changes, and the first two columns are fixed. Power BI natively doesn't support pinning columns in matrix visualizations, but you can achieve a similar effect by carefully arranging the visualization and ensuring that slicers only affect dynamic columns.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Yohua,
Thak you for Quick Resonse, Here i have only Actal table.
No Of custimer i have taken count of S no ..
SBU Name as OEM Name
Please shar dummy pbix file
HI Elite,
Not allowing to share the File here
@Sudhakar1000 just copy 10-20 column replace all the value with fake value and then share the file with mentioning expected output .
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |