Forum Discussion

akashmish's avatar
akashmish
Frequent Visitor
7 years ago
Solved

Toggle between different column values by using slicer

Hi I am new to Power BI, I have a requirement where my data is connected to SSAS cube and my data contains 4 measures say- revenue,sales,profit and volume and say one dimension called country

I want to create a bar chart which shows countrywise - revenue or sales or profit or volume. there has to be a slicer/filter which when selected revenue should show the chart of countrywise revenue, when selected sales should show the chart of countrywise sales and so on.

The only problem that I am facing is that my data is connected to SSAS cube hence I can't create any table/column etc in power query window as it gets disabled while connecting to SSAS. I also don't have access to modify SSAS cube. 

Let me know if there is any workaround to achieve this requirement using calculated measure.


Any help regarding this will be much appreciated.

 

Regards,

Akash

1 Reply

  • SivaMani's avatar
    SivaMani
    Resident Rockstar

    akashmish,

     

    This blog will help you to solve the problem.

     

    • Create four charts for each measure
    • Use bookmarks to switch between them

    Thanks,

    Siva