Forum Discussion

ravimerugu's avatar
ravimerugu
Advocate II
8 years ago
Solved

cross filtering within the same table

Hi,    I am new to Power BI. I am trying to create a report that has a map with the user count in different locations, two stacked bar charts for income range and age groups, and a pie chart for gen...
  • parry2k's avatar
    parry2k
    8 years ago

    basically you need to pivot your table whcih can be achieved thru query editor, here is the link for sample pbix I created from your data as reference.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Your dataset is not well arranged.  It should actually be a 4 column dataset with User_ID, Age, Autos - Income and Gender.  If you do not know how to cary put the transformation, let me know and i will help.

parry2k's avatar
parry2k
Super User
8 years ago

basically you need to pivot your table whcih can be achieved thru query editor, here is the link for sample pbix I created from your data as reference.

  • ravimerugu's avatar
    ravimerugu
    Advocate II
    8 years ago

    Thanks parry2k. It works!!