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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
LDEVIN
Regular Visitor

How can I Show 1 of 2 columns in a table based on a slicer

Simple problem :).  Your help is appreciated

 

I have a Fahrenheit column and a Celsius column of data.  Depending on a slicer value, I would like to show only one of these columns.  Is that possible?  If so, how :).  

 

 

Thanks in advance

LD

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @LDEVIN,

 

In the video link you have the type of calculations and setup you need to do make it work.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

5 REPLIES 5
MFelix
Super User
Super User

Hi @LDEVIN,

 

In the video link you have the type of calculations and setup you need to do make it work.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



this may work, but I can't add data as suggested due to the fact that my data source is an SSAS cube.

I did test this conceptually and it works. Thank you.  I would say, that SSAS cubes means I have to copy the measure to a new measure and add the contains logic.  Thank you.

One last note for anybody else.  This works much better for a graph.   A table will show both columns, but only show the data in the column selected by the chooser.

Hi @

if you add a measure.that makes a switch between both columns you will only get.one value at a time.and not both.

Something like
Measure = SWITCH( TRUE(),
CONTAINS(Slicer, Slicer[Info],"a"), SUM(Table[a]),
CONTAINS(Slicer, Slicer[Info],"b"), SUM(Table[b]),
"No selection"
)

You need to use these measure on your table instead of the original columns to only have a single result.

Change the tables and colums to what you need
Regards,
MFelix

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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