Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

create 2 buttons MARCH, APRIL.

hiii guys

i want to call closed data
i have a column called call closed in that i only want to select march and april data put in the form of two buttons on my screen so that if i select march button my graph displays march data the same for the april button
below is my power bi file

  • A simple way to accomplish your requirement is downloading a custom visual called "Chiclet Slicer" then put your month column and from visual level filter option choose only March and April.

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

    Create a measure

    _month = FORMAT([DATE],"MMM")

    now create a slicer and select Horizontal in Format.

    You will get 

  • A simple way to accomplish your requirement is downloading a custom visual called "Chiclet Slicer" then put your month column and from visual level filter option choose only March and April.

     

  • Icey's avatar
    Icey
    Community Support

    Hi Anonymous ,

     

    Please let us know if the methods above are helpful.

     

     

    Best Regards,

    Icey

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion

    Anonymous 

    Create a slicer using your month column and limit the selection to the months you need by selecting the slicer and checking the relevant months in the Filter Pane (basic selection option)