This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
Hi,
Is it possible to make the category field of treemap visualization to change based on the slicer?
I've created a DAX measure with the SWITCH function to toggle based on the slicer but the Category field of treemap visual is not accepting this DAX measure.
Solved! Go to Solution.
@Dheeraj_Trek , You can create a Field Parameter and pull that into the category field of the Tree Map visual like below
1. Select the field parameter
2. Drag the columns you want to switch between, in my case Country and Product and Click Create
3. Map the Parameter to Category field of Treemap and use the slicer to switch between the fields.
Did I answer your question? If yes, please mark my post as a solution.
Thanks,
Jai
Proud to be a Super User! | |
@Dheeraj_Trek yes possible, you can use the same field parameter for a table visualisation
Proud to be a Super User! | |
@Dheeraj_Trek , You can create a Field Parameter and pull that into the category field of the Tree Map visual like below
1. Select the field parameter
2. Drag the columns you want to switch between, in my case Country and Product and Click Create
3. Map the Parameter to Category field of Treemap and use the slicer to switch between the fields.
Did I answer your question? If yes, please mark my post as a solution.
Thanks,
Jai
Proud to be a Super User! | |
Hi Jai,
Is it possible to link another table visualization with this same slicer created with the above field parameter?
@Dheeraj_Trek yes possible, you can use the same field parameter for a table visualisation
Proud to be a Super User! | |
Thanks Jai!
It works perfectly as I expected.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 14 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 47 | |
| 39 | |
| 24 | |
| 20 | |
| 20 |