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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
AMAN560
Frequent Visitor

how to not show unwanted column in power bi matrix

I have a column Col A containing few values (0 to 90) and I am using this column as slicer in power bi 

I have a calculated measure Measure A of the running sum 

I have put Col A in  column in matrix and put Measure A in values

 

Now increse the slicer columns will also increase in form  0,1,2,3,4,5,6,7,8,9,10..................

But I want the columns for few specific numbers only like 1,2,3,7,10,15,30,60,and 90 only.

 

 

I tried to drag the column and reduce its size to hide after closing text wrap but hiding too many column continuously made a visible space between columns 60 and  90

1 REPLY 1
lbendlin
Super User
Super User

"I have a column Col A containing few values (0 to 90) and I am using this column as slicer in power bi "

 

Use a separate table to feed your slicer, and then use your logic to show only the desired part of the slicer's range, either via measure, or via the data model.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.