To provide navigation in power bi ,through the cell of table visual,that when it clicks it will navigate to another page & show me the drilled down data.

I am trying to use two slicers in Power BI to select the StartYear and EndYear columns for a column chart.
The only two bars on the chart will be the sum of revenue for the selected two years.

I have some data and it came from a manual entry CRM so it has alot of human errors. (which you will see in the Customer Stage, the status will be marked as XXX Error)

Data related to problem

In a table, i have calculated min of a column based on filters on other columns. Now based on the min column, how can i backtrack to the data ,to store it in another column. Please suggest solution.[Power-BI].

I am trying to write DAX that will return the name of a marketing campaign, where the date the person responded to the campaign is less than or equal to the date the opportunity was created. The data is on separate tables.

I am currently working with JSON data in Power BI and I need assistance in extracting and transforming the data into separate tables based on the different key-value pairs in each JSON. I have multiple JSONs with varying structures, and I want to ensure that all the JSONs are properly transformed into individual tables within Power BI.

I’m looking to create a code that allows me to get a value from the below

So, when we’re filtering all data from day, month, and year (selecting all function).
Now, 5 out of 6 visuals are filtering data but 1 isn’t doing that.
Below attached is the[enter image description here](https://i.sstatic.net/TDykjxJj.jpg) query used for filtering and visuals screenshot is attached.

Good afternoon,