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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
giorgiokatr
Helper V
Helper V

table with dynamic values (columns)

is it possible in a table to have dynamic values depending on a slicer?

 

 

Rows will have Branch

and values will have different columns each time i select a value from a slicer

(eg sales when i select sales etc)

each value is a different column on my database

 

1 ACCEPTED SOLUTION

Hi @giorgiokatr,

 

Sorry, It seems like I have forgot to paste the measures.

 

field1 =SWITCH([Selected],"Sales",Max(Table[Col1]),"Other",Max(Table[Col3]))
field2 =SWITCH([Selected],"Sales",Max(Table[Col2]),"Other",Max(Table[Col4]))

 

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

14 REPLIES 14
Hrishid
Regular Visitor

I need some expertise here.

I have imported excel from sharepoint in power bi as dataset.

In power bi desktop i have connected it as live dataset using get data method.

Now the issue is that i want to create the dynamic axis using modelling》parameter》field parameter. But it seems that the parameter is greyedout.

 

Any expert please suggest how can i create dynamic axis [field headers]

Baskar
Resident Rockstar
Resident Rockstar

Cool,

 

1. We can't change the calculated column value while selecting in slicer.

 

but we can achieve whatever u looking for with the help of Calculated measure. please share your fromula .

i am sharing my pbix to help you understand if it is possible!

https://drive.google.com/file/d/0Bw-_YmJ3Q49gTzVKUjdhUEZUQ0U/view?usp=sharing

Hi @giorgiokatr,

 

You can refer to below method to show the dynamic fields value.

 

Add a index column to current table.(let measure calculate all the rows)

 Capture.PNG

 

Add a measure to slicer's source table to get the selected value.

Selected = if(HASONEVALUE(selection[Slicer]),VALUES(selection[Slicer]),BLANK())

 

Create the table visual.

Capture2.PNG

 

Result:

Capture3.PNGCapture4.PNG

Notice: if table not contain the index column, it will only show one value.

 

Capture5.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

thanks @v-shex-msft! what is the dax formula for field1 and field2?

Hi @giorgiokatr,

 

Sorry, It seems like I have forgot to paste the measures.

 

field1 =SWITCH([Selected],"Sales",Max(Table[Col1]),"Other",Max(Table[Col3]))
field2 =SWITCH([Selected],"Sales",Max(Table[Col2]),"Other",Max(Table[Col4]))

 

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi v-shex-msft,

 

 

 

Anonymous
Not applicable

Is it possible to do this when your measures use different formatting?

I have three measures that my users need to be able to swap out in the same field.  This worked for the first two, which are the same format (whole number), but the third value is a percentage.  Using this process I've only been able to keep all in the same format (whole number or percent for all).

hi @v-shex-msft

Could be please send the pbix file with multiple rows in the input table.

I am not able to see the exact output, I see the max value of the list of values in the columns as the DAX epression says(Max in it).

Thanks in advance.

Regards,

Pramod Kumar

thanks @v-shex-msft great and clever solution!

and my only remaing problem @v-shex-msft is how to name dynamic the field1 and field2..... 

because noone will know that field1 has the values of column1

BetterCallFrank
Resolver IV
Resolver IV

Hi @giorgiokatr

 

look at my previous answer at https://community.powerbi.com/t5/Desktop/Changing-column-graph-displayed-value/m-p/108427/highlight/... - this is a good pattern to make it work like you want 🙂

 

HTH,

Frank

thanks @BetterCallFrank!

switch i a good solution but i would like to have 5 values for example not only one depending on slicer selection.

example when i select sales from slicer to have in a table my 5 sales columns (phone sales, laptop sales eg)

when i select profit to have my other 5 profit columns...

Hi @giorgiokatr

 

Can you share some data and the visual you expect to understand the problem better.  You can do this on onedrive and post the link

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.