Forum Discussion

biloser's avatar
biloser
Regular Visitor
9 years ago
Solved

How to apply time intelligence/ use a time slicer

Hello, maybe someone is able to help me to apply time intelligence to my visualization in power Bi. I want to use a time slicer so that the values of my bar chart will change according to the date. ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi biloser,

     

    After looking into your shared pbix file, I found the "table2" is not needed. You can just add the following 3 measures in "table1", then you should be able to create a relationship between "DateDimension" table and "table1", and use a time slicer so that the values of the bar chart will change according to the date.

    Measure Percentage Car 1 = [SUM Car 1]/[SUM Amount]
    Measure Percentage Car 2 = [Sum Car 2]/[SUM Amount]
    Measure Percentage Car 3 = [SUM Car 3]/[SUM Amount]

    Here is the modified pbix for your reference.:smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi biloser,

 

After looking into your shared pbix file, I found the "table2" is not needed. You can just add the following 3 measures in "table1", then you should be able to create a relationship between "DateDimension" table and "table1", and use a time slicer so that the values of the bar chart will change according to the date.

Measure Percentage Car 1 = [SUM Car 1]/[SUM Amount]
Measure Percentage Car 2 = [Sum Car 2]/[SUM Amount]
Measure Percentage Car 3 = [SUM Car 3]/[SUM Amount]

Here is the modified pbix for your reference.:smileyhappy:

 

Regards

  • biloser's avatar
    biloser
    Regular Visitor
    9 years ago

     v-ljerr-msft Thanks a lot for your advice!! 

    It helped me a lot, now it is working like I wished :smileyhappy:

     

    Best Regards