Forum Discussion

machbi's avatar
machbi
Regular Visitor
9 years ago

Build calculated column to flag Latest month data based on Slicer(s)

Hi Power BI Community,   Hoping I can get some direction on this roadblock I'm facing on a report.  On my report, I have a bar chart that shows 12 months of data along the X axis.  There are also 6...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi machbi,

What fields do you use to create the 6 slicers? Could you please post sample data of your tables so that we can test?

Thanks,
Lydia Zhang

machbi's avatar
machbi
Regular Visitor
9 years ago

Thanks Anonymous .  I just put together a sample PBIX file.  How can I upload/share?

 

 

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Hi machbi,

     

    If you upload to your preferred cloud file storage tool (eg One Drive, Dropbox etc), you can often "get a link" to share a read only copy of that file that we can use to download and use to help you with.

     

     

    • machbi's avatar
      machbi
      Regular Visitor
      9 years ago

      Here's the link to download the sample PBIX file.  Thank you all for your help.

       

      Power BI Sample File

       

      Thanks for the tip Phil_Seamark.  Was originally looking for an internal PBI community attachment option, but this works as well.