Line Graph stop based on Selected Month

[MK3010]

Hi @LeeC

Is it possible for you to share demo pbix file with sample data.

You need to create Disconnected table. and then using that in your DAX calculation. Below is one link where you can find some details(it’s matrix but can change to graph)

Current period vs. previous period WITHOUT date column

Hi @corkemp You need to create 2 disconnected table from the main table. Table 1– Goto “Data” view and select “New Table” Use below DAX to create new table with table name “SelectedRCy1”(you can change as per your choice) SelectedRCy1 = DISTINCT('Masked Report Data'[Report Cycle Name]) Rename the column as “Selection 1” Table 2– Goto “Data” view and select “New Table” Use below DAX to create new table with table name “SelectedRCy2”(you can change as per your choice) Selecte…