Forum Discussion

SpiroswayGR's avatar
SpiroswayGR
Resolver III
6 years ago
Solved

How to create two or three Switches

Greetings everyone!! It's urgent problem!!   I would to explain mine urgent problem that i have when i need to create switch slicers. Our PBI report should be like this https://prnt.sc/ql5uio .  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI SpiroswayGR,

I'd like to suggest you unpivoted these columns to attribute and value, then you can simply write measure formula to switch between different fields:

Unpivot columns (Power Query) 

Regards,

Xiaoxin Sheng

SpiroswayGR's avatar
SpiroswayGR
Resolver III
6 years ago

Thank you Anonymous .

 

With your suggestion i manage to solve the 1st part of problem.(About Net / Gross values).

 

What about "Slicer" dates button? I have the "Date" column.

So the suggestion is to create Past - Future - All season .

Past = 01/01 until yesterday 

Future = Today until end of the year 31/12

All Season = 01/01 to 31/12

 

In that i want to click on these specific slicer button and i want to see the different "Revenue values etc".

 

Thank you in advance for your time.

  • SpiroswayGR's avatar
    SpiroswayGR
    Resolver III
    6 years ago

    Anonymous 

    Any idea how can we produce the 2nd part of solution ? 

     

    Thank you again !!