none
Filters in power BI RRS feed

  • Question

  • Hello Members,

    I am new to powerBi and struggling with the filters in power bi. 

    Q1 : Can't we assign filters as measures  to a data column eg: ColumnSalesValue = Somecalculatedvaluebymeasure.

    How do we achive this goal.

    Q2. I have financial years in a date table 

    eg.

    Financial year  

    2015

    2016

    2017

    2018

    2019

    2020

    I want a measure to calculate the current financial year(which i have eg..2019 for current year<currfinyr>) and previous financial year.

    The purpose is to display both years i.e 2018 and 2019 on a line graph for comparisons. How do I achieve this.

    I do not want to hard code the values and want the system to do it. 

    I tried taking the financial year into the filters but could not assign <currfinyr>

    Is there any way I can achieve this. 

    Thanks in advance.



    • Edited by suvidip Monday, September 30, 2019 11:51 AM
    Monday, September 30, 2019 11:50 AM

Answers