Forum Discussion

kabra_ashish's avatar
kabra_ashish
Helper III
5 years ago
Solved

KPI Visual

I have a Data table and a fact table.   Date table - It has all the dates starting 01-Jan-2019 until 31-Dec 2020. Custom created few more fields like Year, Month and "Month & Year".   Fact table...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi,kabra_ashish 

     

    According to your description, I tested it, I think you need to put the field of the slicer on KPI 'trend axis', for example, ‘month&year’.

    Like this:

    Here is my sample .pbix file.Hope it helps.

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi,kabra_ashish 

 

According to your description, I tested it, I think you need to put the field of the slicer on KPI 'trend axis', for example, ‘month&year’.

Like this:

Here is my sample .pbix file.Hope it helps.

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.