Hi all,
I have one table called [ETO] that has a bunch of rows with columns like
Job
Month
Value
Supervisor
Sales Consultant
Suburb
I would like to be able to have a single visual or table based upon sum(value), count(jobs) and month and then using a slicer - dynamically add either the Supervisor, Sales Consultant or Suburb field into the visual
This idea of it works by creating a calculated column in my table like this
ColumnTest = if(CALCULATE(VALUES( ETO[Supervisor]),ETO[Supervisor]]= "John Smith") = "John Smith", ETO[Supervisor], ETO[Suburb])
and then creating a slicer on column ETO[Supervisor] and choosing 'John Smith' - it will change the value of ColumnTest
However I believe the slicer cannot be related to my table if I wish to get useful results, so I created a second table [Table1] with the values in a column called Chooser
Supervisor
Sales Consultant
Suburb
I then create a slicer on this table in my report
And in my [ETO] table I created a calc column similar to the above
DynamicColumn = if(CALCULATE(VALUES( Table1[Chooser]),Table1[Chooser] = "Supervisor") = "Supervisor", ETO[Supervisor], ETO[Suburb])
However the new ETO[DynamicColumn] only returns me names of Supervisors regardless of what the slicer Table1[Chooser] selection is
I was able to do this in a tableau report by creating a parameter with possible values and a dynamic column with nested case statements eg. NewColumn = case when parameter = 'Supervisor' then 'SupervisorColumn else 'SuburbColumn end
Is it possible to do something similar in Power BI
Thanks
Anthony
