Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Sudhakar1000
Helper III
Helper III

How to show static column in matrix power bi

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

 

Sudhakar1000_0-1727775228211.png

Looking Result. If select Apple first two column fixed , 3rd column will get change based product .

Sudhakar1000_1-1727775983043.png

 

1 ACCEPTED SOLUTION
Sudhakar1000
Helper III
Helper III

Hi All,

 Now its working fine..

I have tried the below Measure..

= IF(ISBLANK(
CALCULATE(
    COUNTA('1200NamedSum'[SBUName]),
    '1200NamedSum'[SBUName] = SELECTEDVALUE('1200NamedSum'[SBUName])
)),0,CALCULATE(
    COUNTA('1200NamedSum'[SBUName]),
    '1200NamedSum'[SBUName] = SELECTEDVALUE('1200NamedSum'[SBUName])
))

 

Sudhakar1000_0-1727958467935.png

 

View solution in original post

6 REPLIES 6
Sudhakar1000
Helper III
Helper III

Hi All,

 Now its working fine..

I have tried the below Measure..

= IF(ISBLANK(
CALCULATE(
    COUNTA('1200NamedSum'[SBUName]),
    '1200NamedSum'[SBUName] = SELECTEDVALUE('1200NamedSum'[SBUName])
)),0,CALCULATE(
    COUNTA('1200NamedSum'[SBUName]),
    '1200NamedSum'[SBUName] = SELECTEDVALUE('1200NamedSum'[SBUName])
))

 

Sudhakar1000_0-1727958467935.png

 

v-yohua-msft
Community Support
Community Support

Hi, @Sudhakar1000 

Based on your information, I create sample tables:

Actual table

vyohuamsft_0-1727845856152.png

Customer table

vyohuamsft_1-1727845868530.png

 

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:

vyohuamsft_2-1727846047422.png

 

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.

vyohuamsft_3-1727846101516.png

 

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

Sudhakar1000_0-1727935897451.png

 

elitesmitpatel
Solution Supplier
Solution Supplier

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 .

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.