Assigning measure as a value to a category But doesn't Work

[Ibrahim_shaik]

Hi Power Bi Community,

I have a table which has per hour data of three months and I have a measure on a specific column in that table and now i have created a new table which has two columns and 8 rows the columns are category and value one category value should be dynamic. 

I have assigned the category value as the measure that i have created previously in the table which has three months data. for the remaining categories in the table i have assigned category values as static values which does not change and I created a measure which takes the value for one category as measure and for other categories i have assigned value. I have want to display it on a column chart so I placed the category and date in the x axis field and the measure in the Y axis field and tried to filter the with the date slicer but the chart doesn't filter according to the date selected.

It shows value as 1 for the column which i have assigned the measure.

please suggest a solution.

Thanks & Regards,

Ibrahim.

[Ibrahim_shaik]

the measure that I have assigned as a value in the table 2 that uses the date column in it. it's the table 1 measure that I am assigning as a value in table 2.

[Anonymous]

Hi @Ibrahim_shaik 

Can you provide some sample data and the picture of the output you want so that can provide more suggestion for you.

Best Regards!

Yolo Zhu

[Ibrahim_shaik]

Hi @Anonymous ,

I was able to solve it.

Thank you.

[amitchandak]

@Ibrahim_shaik , Based on what I got

if you have created Table 2 from Table 1 then the data of the Table2 will not change based on the slicer from Table1

Both tables need to use a common slicer or measure should filter data for table2 using table1's slicer