Forum Discussion

JAVED's avatar
JAVED
Helper I
8 years ago
Solved

Filter Data

Hi! I am new to power bi, I am laging with a problem i have 2 columns one contains Different Products like p1,q2,r1,s6,t4,a4,b5,c8,d9 etc... and in another other column i have cost of that Products ...
APIS and Embedding
Content Packs
Custom Visuals
Dashboards
Data Modeling
Gateways
Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi JAVED,

     

    You can create a calculated column below: 

     

    Column = IF('Table1'[Products]="p1"|| 'Table1'[Products]="p2"||'Table1'[Products]="a4"||'Table1'[Products]="q2"||'Table1'[Products]="s1"||'Table1'[Products]="c3",'Table1'[cost],0)

     

     

    Best Regards,
    Qiuyun Yu 

JAVED's avatar
JAVED
Helper I
8 years ago

sry it should display only p1,p2,a4,q2,s1,c3 values

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi JAVED,

 

You can create a calculated column below: 

 

Column = IF('Table1'[Products]="p1"|| 'Table1'[Products]="p2"||'Table1'[Products]="a4"||'Table1'[Products]="q2"||'Table1'[Products]="s1"||'Table1'[Products]="c3",'Table1'[cost],0)

 

 

Best Regards,
Qiuyun Yu 

  • JAVED's avatar
    JAVED
    Helper I
    8 years ago

    Can we display last 6 months data in graph even.even thought there is no data for 3 months

    Example  i need to diaplay last 6 months data when i write a query it is dispalying data from today to feb-23-2018, But in my data base i don't have may,June,July,Agust data,in the bar graph it is shown only feb ,Mar,apr in bar graph. But i need to display may,june,july names also even it is empty.

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      8 years ago

      Hi JAVED,

       

      This is a different issue from the original one. I would suggest you post a new thread in Power BI desktop forum with some dummy data and clarify corresponding desired results. 

       

      Best Regards,
      Qiuyun Yu