Forum Discussion

estgas's avatar
estgas
Frequent Visitor
8 years ago

Switch a visualized table column with slicer

Hi All, after reading several posts on similar topic I could not find one solving my issue.   I have a table with columns: Product, Subcategory, Category, Date and Sales value and would like a visu...
Need Help
estgas's avatar
estgas
Frequent Visitor
8 years ago

Hi all, many thanks for your answers although I am afraid it would be difficult to apply the proposed solutions.

 

The problem is that my report contains a DOZEN of sheets, each sheet contains a table with a different dimension (Product, Category, Region, Month, Color, Responsible, Sales, Cost, Margin, etc) and additional dozen of columns with different calculations.

 

I am looking to have only ONE sheet from where the user can choose the interested column dimension instead of several sheets.

 

I was hoping to find some easy solution like this similar case https://community.powerbi.com/t5/Desktop/table-with-dynamic-values-columns/td-p/110266 that switches the columns, but do not aggregates the values because of the index column.

 

Kind regards

estgas