Forum Discussion

riteshgaur's avatar
riteshgaur
Frequent Visitor
7 years ago
Solved

Union two tables based on Slicer

Hi All,   I am new to Power BI world. My requirment is to display a SLICER with Key values which has Year part like Rxxxxx17xxxx, now based on slicer selected value, I have to display data for Rxx...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi riteshgaur ,

     

    Do not know your requirement, have you build relationship or add an index column to the two tables? If you have, you may drag columns to chrart directly.

     

    Regards,

    Jimmy Tao

riteshgaur's avatar
riteshgaur
Frequent Visitor
7 years ago

Hi Manohar,

 

RiskKey            Amount

RAB17001       100.00

RAB18001       200.00

BUJ17001        239.00

BUJ18001        344.00

 

So, If in Slicer fro RiskKey, RAB17001 is selected, which is for year 2017, report should display RAB17001 and RAB18001 data.

I manage to display them in seperate table but not able to display together.

 

Thanks in advance.

 

RG

  

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi riteshgaur ,

     

    Do not know your requirement, have you build relationship or add an index column to the two tables? If you have, you may drag columns to chrart directly.

     

    Regards,

    Jimmy Tao